View Full Version : Countif(between two values)


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?

shades
12-06-2005, 12:37 PM
Howdy. With two conditions, use SUMPRODUCT.

=SUMPRODUCT(($K$2:$K$419>0)*($K$2:$K419<0.5))