Thread: COUNTIF
View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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"