Thread: CountIF
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
cteacher cteacher is offline
external usenet poster
 
Posts: 5
Default 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!