G
Guest
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"
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"