Tally with multiple condition

**Hootie** · 08-04-2010, 09:47 AM

Hi, good morning thank you in advance, I am stumped and need help please.

I have a spreadsheet that will have multiple columns, one column will have a status update, "completed" "Not Remedied" "Need Review". Will have diff issues like "Prob A" "Prob B" "Prob C."

I want to make a sum of the number of each problem, with each status, so how many "Prob A" with "Completed" with "Not Remedied" etc... "Prob B" with "Completed" with "Not Remedied" etc..

I will attach a spreadsheet below, any help would be much appreciated, thanks

**arthurbr** · 08-04-2010, 09:56 AM

Is the attached what you need?

**Hootie** · 08-04-2010, 10:12 AM

Thank you!! you rock! that is awesome I need to look up and figure out how to work that command!!

Have a great day!

**arthurbr** · 08-04-2010, 10:20 AM

The place to be for explanations on SUMPRODUCT is here

**arthurbr** · 08-05-2010, 04:59 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save