Thread: COUNTIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
littlejess22 littlejess22 is offline
external usenet poster
 
Posts: 8
Default COUNTIF

Can anyone tell me what I'm doing wrong in this formula?

-2
-1
0
1
2
3
4
5
6

=COUNTIF(A1:A9,"=0"&"<5")
I looked at the help section and it seemed to suggest you use '&' when you
have two criteria, is this where I'm going wrong? The answer should be 5,
but it returns 0. I'm looking to find those numbers above zero and below
five.

Thanx