RaunLGoode
Registered User.
- Local time
- Today, 10:11
- Joined
- Feb 18, 2004
- Messages
- 122
I am trying to count values between 0 and .5 Using COUNTIF to interrogate a Range (K2:K419)
I can do a COUNTIF for either value, but not both. I tried to morph a COUNTIF formula and an "AND" operator
=COUNTIF(AND(0<K2:K419, K2:K419<.5) )....which doesn't work
Could somebody help me?
I can do a COUNTIF for either value, but not both. I tried to morph a COUNTIF formula and an "AND" operator
=COUNTIF(AND(0<K2:K419, K2:K419<.5) )....which doesn't work
Could somebody help me?
Last edited: