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

--
Message posted from http://www.ExcelForum.com

try using the subtotal function

it's something like this

=subtotal("a",a1:a10)

:cool

--
Message posted from http://www.ExcelForum.com

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

"SaraK " wrote in message
...
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 the
Range Two equals GroupX. The data is all text.

Thanks !


---
Message posted from http://www.ExcelForum.com/

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

--
Regards
Frank Kabel
Frankfurt, Germany

"SaraK " schrieb im Newsbeitrag
...
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 the
Range Two equals GroupX. The data is all text.

Thanks !


---
Message posted from http://www.ExcelForum.com/