ExcelBanter - Countifs

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Countifs (https://www.excelbanter.com/excel-worksheet-functions/228534-countifs.html)

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?

Take a look COUNTIFS() in Help menu

"Carl" wrote:

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?