Multiple SUM Criteria - DSUM and SUMIFS not working :-(

Hi all,

Hope all is well.

I have run into a wall with this one and cannot figure it out...

I am trying to sum a range based on multiple criteria - sounds simple enough right?!

However I cannot achieve the correct result.


Could someone please have a look - I have included a very brief example and notes in the attached workbook.


Thanks in advance everyone!


Coeus.

Hi Coeus,

Could you share what is the expected result that you would want to displayed in F2?

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Hi,

Sorry for not explaining myself better,

The results would total only those with classes 2, 3, and 5.

So the results shown should be:

A 90
B 60
C 140
D 60
E 90




Thanks,

No worries, try F2=SUMPRODUCT(Table1[SCORE]*(Table1[NAME]=[@NAME])*(ISNUMBER(MATCH(Table1[CLASS],$H$2:$H$4,0))))

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Hi all,

Didn't want to ask and run.

Thank you very much for your help. I was hoping for a simpler solution - not for myself but other less Excel-savvy need to understand the formulas and that would be a bit beyond them but it does work!


Many thanks for your help, really appreciate it.


Regards,


Coeus.