Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm trying to count the number of cells that meets both of two arguments.
When I consulted Excel 2003 HELP, it suggested that I use =COUNTIF(B1:B3,"=32")-COUNTIF(B1:B3,"85") With the description "Number of cells with a value greater than or equal to "A" and less than or equal to "B" But what it actually returns is the DIFFERENCE between A & B (see the minus sign between the two arguments?) Obviously I need a formula that would return a count of the number of cells in a range of multiple cells that meets BOTH greater than "A" AND less than "B" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Countif - Countif | Excel Worksheet Functions | |||
Countif ??? | Excel Worksheet Functions | |||
countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions | |||
combining countif formulas | Excel Worksheet Functions |