COUNTIF Help
 

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

COUNTIF Help
 

not sure I understand what you want to do but

=sumproduct((Data!$C$2:$C$191=Summary!B$3)*(Data!$ M$ 2:$M$191="X"))

i think will do it - count x's in column M subject to meeting critiera
for column C


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=496437