formula if

  1. L

    Solved SUMIFS help

    I need help coming up with an excel formula I'm not sure if I need a SUMIF, SUMIFS or some other formula. Each patient is assigned codes (B2:E2) and each code has a value (A5:B11). I need to add up the total value for each patient. The example below only gives a total of one code (in C2)...
  2. N

    Solved Excel IF formula problems

    Dear Tech guys, I am trying to implement an excel sheet which reports information from another excel sheet and monitors it. My excel file has several sheet. The first one acts as a "general dashboard" where all the information from the other sheets are reported. Here is an example of the issue...