VLOOKUP Multiple re-occurring codes in the database

Hi ehernandez,

Martin is correct, you should use SUMIFS or just SUMIF functions.

This is what I would use in Q3 = SUMIF('Surgery MCare'!$A$2:$A$41,D3,'Surgery MCare'!$G$2:$G$41), then use the same logic to the rest of the columns.

You have to make sure to use the dollar signs ($) to fix your range. Without the $ signs, the range was changing too, which I don't think you want.

Look up what the SUMIF formula and what it needs... type the formula and a helper should pop-up for more info.

Good luck,
Dennis

Thank you for the quick response, the SUMIF function worked wonderfully .