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