sum

  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. E

    Lookup Sum of Table by Week

    Hi All, I'm trying to look up / match the weekly sum without putting in a summary column per week. e.g. return the sum of ('John'!)B5:H5 into cell ('Weekly Summary'!)B4. Look up value column A. I've attached an example of what I'm trying to do.
  3. K

    Solved Need help with Excel formula

    I attached a picture of the spreadsheet/current formula. I would like to add another formula into cell K101 so that when a value is entered into M101, K101 goes to 0.
Top