CountIF
Hi Bob.
Thank you!!!!! This it it!!!!!!!!!
Bob Phillips wrote:
=SUMPRODUCT(--(D2:D239),--(D2:D23<20))
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!
|