RaunLGoode
12-06-2005, 11:57 AM
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?