| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countifs
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countifs
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIFS with an OR? | Excel Worksheet Functions | |||
| Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr | Excel Worksheet Functions | |||
| Countifs | Excel Worksheet Functions | |||
| Countifs Fx in 07 how in 03? | Excel Discussion (Misc queries) | |||
| countifs | Excel Discussion (Misc queries) | |||
Linear Mode
