Countif(between two values) (1 Viewer)

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?
 
Last edited:

shades

Registered User.
Local time
Today, 10:11
Joined
Mar 25, 2002
Messages
516
Howdy. With two conditions, use SUMPRODUCT.

=SUMPRODUCT(($K$2:$K$419>0)*($K$2:$K419<0.5))
________
Futura
 
Last edited:

Users who are viewing this thread

Top Bottom