=SUMPRODUCT(--(D2:D239),--(D2:D23<20))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"cteacher" <u27106@uwe wrote in message news:66d3c360a0feb@uwe...
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!