C
Carl
Excel 2007: Trying to use Countifs
To simplify, in column B, over the range B2:B1250, I have the letters a,b,c,d
I need a count of "a", =countif( B2:B1250,"a"). This is 149
To get a count of "b", =countif( B2:B1250,"b") This is 22
I had never used the new countifs function so I tried it
=countifs(b2:b1250,"a",b2:b1250,"b") I get zero (0) rather than 171. I
even tried to array enter the formula.
Does this not work withing the same range, as I am attempting to do?
To simplify, in column B, over the range B2:B1250, I have the letters a,b,c,d
I need a count of "a", =countif( B2:B1250,"a"). This is 149
To get a count of "b", =countif( B2:B1250,"b") This is 22
I had never used the new countifs function so I tried it
=countifs(b2:b1250,"a",b2:b1250,"b") I get zero (0) rather than 171. I
even tried to array enter the formula.
Does this not work withing the same range, as I am attempting to do?