COUNTIF with nestled IF?

[Scott Calkins via OfficeKB.com]

I have 2 columns of data containing lettere only. I.e. column A is
A,A,B,B,C,C, etc and column B has "S"s and "E"s in it. I want to just
count the total "A"s in column A, but only if the matching cell in column B
is "S". Is there a way to nestle in a "if" into the countif function?
ie =countif(a:a,"B",if(b:b="S"))
Scott

 

[Peo Sjoblom]

=SUMPRODUCT(--(A2:A500="A"),--(B2:B500="S"))

 

[Bob Phillips]

Note that you cannot use a whole column with this method (as Peo shows) as
you can with COUNTIF/SUMIF, you must use a defined range.

--

HTH

RP
(remove nothere from the email address if mailing direct)