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/