Hi!

Try this:

=SUMPRODUCT(--(A1:A5="Ford"),--(B1:B5="June"))

Biff

"serve" wrote in message
...
A B
1 Ford June
2 Ford May
3 BMW June
4 Ford June
5 Ford June
I need to COUNT how many "Fords" have the value of June - the answer
should
be 3 in this sample. I tried sumif, countif, sumproduct, maybe I need a
combination?
Thanks.