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
Bookmarks