COUNTIF on one ranges with criteria from another

[SaraK]

Hello,

I want to perform a countif on a given range e.g.:
COUNTIF (G12:G29,"A")
after checking for a different criteria in a different range;
say A12:A29 equals GroupX.

In otherwords, how do I only count the C's in Range One when th
Range Two equals GroupX. The data is all text.

Thanks

 

[Phonio]

try using the subtotal function

it's something like this

=subtotal("a",a1:a10)

:cool

 

[Bob Phillips]

=SUMPRODUCT((A12:A29="GroupX")*(G12:G29="A"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
try something like
=SUMPRODUCT(--(A12:A29="GroupX"),--(G12:G19="A"))