Sorry .. but what are the two dashes in front of the bracket? I have 2003
version so must use Sumproduct.

"T. Valko" wrote:

Try one of these.

All versions of Excel:

=SUMPRODUCT(--(A1:A10="A"),--(B1:B10="B"))

Excel 2007 only:

=COUNTIFS(A1:A10,"A",B1:B10,"B")

--
Biff
Microsoft Excel MVP


"chris" wrote in message
...
how do you countif ... if range 1 ="A" and range 2 = "B"