Hi Rob,

This only gives me a zero. Looking at my range of numbers, it should be 1.

Rob J wrote:
Try this...

=countif(d2:d23,and(9,<20))

Using AND should check that both conditions are true before returning true
to the countif.

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!