COUNTIF Help

R

raspywench

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!
 
D

duane

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 critier
for column
 
Top