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