MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Mark on February 05, 2002 4:53 AM

Can anyone tell me how I can use SUMIF and/or COUNTIF to check against two if column A = "Fred" and Column B = "Wilma" then SUM / COUNT Column C.

The only way I can think of doing it is by adding in another column where an IF statement does the check.

Posted by Aladin Akyurek on February 05, 2002 5:57 AM

SUMPRODUCT for Multiconditional Counting & Summing


will give you the count of the co-occurrence of Fred and Wilma.

=SUMPRODUCT((A2:A100="Fred")*(B2:B100="Wilma"), (C2:C100))

will give you a total that correspond to occurrences of Fred & Wilma.


Posted by Mark on February 07, 2002 1:54 AM

Excellent - Thank you!

That was perfect.....thanks