countif two corresponding cells meet the criteria

[chris]

how do you countif ... if range 1 ="A" and range 2 = "B"

 

[T. Valko]

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")

 

[chris]

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

 

[T. Valko]

See these:

http://xldynamic.com/source/xld.SUMPRODUCT.html

http://mcgimpsey.com/excel/formulae/doubleneg.html