CountIF
Try this...
=countif(d2:d23,and(9,<20))
Using AND should check that both conditions are true before returning true
to the countif.
"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!
|