Hello,
I am trying to get a formula correct that basically performs the
following function:
=COUNT(IF(Data!$C$2:$C$191=Summary!B$3,IF(Data!$M$ 2:$M$191,"X",0)))...
But I want it to return the count of the "X"s in that column (right now
it omits the "X"s and counts the other cells.
Also, if I wanted to use this same formula and have it count the number
of "1"s, "2"s, or "3"s in a column, how would I do that?
Any help is appreciated! Thank you!
--
raspywench
------------------------------------------------------------------------
raspywench's Profile:
http://www.excelforum.com/member.php...o&userid=20717
View this thread:
http://www.excelforum.com/showthread...hreadid=496437