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