Hi,

You may also want to try using an array formula although sumproduct is
definitely a better solution

=sum(if(($A$1:$A$5="Ford")*($B$1:$B$5="June"),1,0) )

confirmed by a Ctrl+Shift+Enter

Regards,

Ashish Mathur

"serve" wrote:

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.