CountIF
=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
--
Brevity is the soul of wit.
"cteacher" wrote:
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!
|