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