countif two corresponding cells meet the criteria
 

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

countif two corresponding cells meet the criteria
 

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"

countif two corresponding cells meet the criteria
 

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"

countif two corresponding cells meet the criteria
 

See these:

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

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

--
Biff
Microsoft Excel MVP


"chris" wrote in message
...
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"