COUNTIF

[littlejess22]

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

 

[Stefan B Rusynko]

You should be asking in an Excel Newsgroup
- This is a FrontPage Newsgroup



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| 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
|

 

[Tom [Pepper] Willett]

Hard to say, since it's an Excel question posted in a FrontPage newsgroup
;-)
Try the Excel newsgroups.
--
===
Tom [Pepper] Willett
Microsoft MVP - FrontPage
"You're a daisy if you do!"
---
FrontPage Support:
http://www.frontpagemvps.com/
===
: 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
: