HOW TO COUNT VALUES BASED ON MULTIPLE CRITERIA IN EXCEL?

[Gabi]

I am trying to count values in column A based on matching criteria in columns
B and C. I have found a formula in Exel, but it keeps giving me a "0"
response.
Does anyone know how to do this? here is the formula i am using thus far:
=COUNT(IF((A2:A10="RED")*(B2:B10="M"),C2:C10))
but it keeps returning result as 0
Help!
thanks

 

[Frank Kabel]

Hi
try
=SUUMPRODUCT(--(A2:A10="RED"),--(B2:B10="M"),C2:C10)

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Aladin Akyurek]

=COUNT(IF((A2:A10="RED")*(B2:B10="M"),C2:C10))

which must be confirmed with control+shift+enter (instead of just wit
enter), would count every record with "RED" in A2:A10, "M" in B2:B10
and a number or nothing in C2:C10. Nothing means empty, not a formul
blank (i.e., ""). This does not seem to fit your task statement: "I a
trying to count values in column A based on matching criteria in column
B and C." If you want to sum C2:C10 when A2:A10 is "RED" and B2:B10 "M"
you have to replace COUNT with SUM or switch to:

=SUMPRODUCT(--(A2:A10="RED"),--(B2:B10="M"),C2:C10)

which just needs enter.

Otherwise, try to elaborate on the task you want to accomplish.