Countif with two terms

[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?

 

[Don Guillett]

=sumproduct((a2:a22="f")*(b2:b22="x"))

 

[Ron Coderre]

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

 

[David Biddulph]

=SUMPRODUCT(--(A1:A100="F"),--(B1:B100="x"),--(C1:C100="y"))