SUMIF & COUNTIF
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 columns....ie 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
=SUMPRODUCT((A2:A100="Fred")*(B2:B100="Wilma"))
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
