Hi there,

I am trying to do a sum with 3 different criteria. If you open up the attached spreadsheet if will hopefully make more sense. What I want to do is a sum if the top row equals 5, the send row equals 2, and the person is a particular number in column A, for this example let's pick out "PERSON 1".

So I should get an answer that is 12+3+7=22. How on earth do I do this. I would really appreciate your help and thanks in advance!

DIFFICULT SUM.xlsx