software

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,quot;Xquot;,0)))...

But I want it to return the count of the quot;Xquot;s in that column (right now
it omits the quot;Xquot;s and counts the other cells.

Also, if I wanted to use this same formula and have it count the number
of quot;1quot;s, quot;2quot;s, or quot;3quot;s in a column, how would I do that?

Any help is appreciated! Thank you!--
raspywench
------------------------------------------------------------------------
raspywench's Profile: www.excelforum.com/member.php...oamp;userid=20717
View this thread: www.excelforum.com/showthread...hreadid=496437
not sure I understand what you want to do but

=sumproduct((Data!$C$2:$C$191=Summary!B$3)*(Data!$ M$ 2:$M$191=quot;Xquot;))

i think will do it - count x's in column M subject to meeting critiera
for column C--
duane------------------------------------------------------------------------
duane's Profile: www.excelforum.com/member.php...oamp;userid=11624
View this thread: www.excelforum.com/showthread...hreadid=496437