Countif with two terms

  • Thread starter Thread starter FreddieP
  • Start date Start date
F

FreddieP

Hi, I would like to count the number of the letter F in column A if column
B=x and column C=y (both terms must be fulfilled.)

I tried countif with no success.

what formula should I use?
 
Try one of these:

=SUMPRODUCT(--(A2:A20="F"),--(B2:B20="X"),--(C2:C20="Y"))
or...
=SUMPRODUCT(--(A2:A20="F")*(B2:B20="X")*(C2:C20="Y"))

Alternatively, if "X" and "Y" refer to values in other cells,
perhaps something like this:
=SUMPRODUCT(--(A2:A20="F"),--(B2:B20=D1),--(C2:C20=E1))

Adjust range references to suit your situation.

Does that help?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel
 
Back
Top