Dave,

I guess you intended to say
=COUNTIF(D2:D23,"<20")-COUNTIF(D2:D23,"<9")

Note the commas between the arguments for the COUNTIF function, and also the
positioning of the double quotes.
--
David Biddulph

"Dave F" wrote in message
...
It gave you -1 because I reversed it.

It should be:

=COUNTIF(D2:D23<"20")-COUNTIF(D2:D23<"9")

Sorry about that.

"cteacher" wrote:

Hi Dave,

When I tried this formula it gives me a -1 and not 1.

Dave F wrote:
=COUNTIF(D2:D23<"9")-COUNTIF(D2:D23<"20")

Subtract the count of numbers less than 9 from the count of numbers less
than 20, and you will have the count of all numbers from 9 to 19,
inclusive.

Dave
I am trying to count a range of cells with multiple conditions. I know
CountIf will not allow two conditions; however, I am trying to count
cells
with numbers in cells D2:d23 9 and <20.

Please help!