Thread
:
COUNTIF
View Single Post
#
2
Frank Kabel
Posts: n/a
Hi
but this is just what the formula does?
Have you tried it?
--
Regards
Frank Kabel
Frankfurt, Germany
"Laura Mc" <Laura
schrieb im Newsbeitrag
...
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"
Reply With Quote