Tech Support Guy banner

Discussions Showcase Albums Media Media Comments Tags

1-3 of 3 Results
  1. Business Applications
    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). How...
  2. Business Applications
    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. Business Applications
    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.
1-3 of 3 Results