=COUNT(IF(AND(K2:K20>=382,K2:K20<=383),IF(E2:E20="x",1,0)))

[Guest]

k2-k20 is a range of numbers
E2-E20 include X as a name

I'm attempting to count all the instances in which x exist between 382 and
383 in the k colum.
I'm using a count(if(...)) array formula to count all of the information.
The second example of count if in excel tutorial, under "Count how often
multiple text or number values occur by using functions" only matches one
text parameter to one number parameter. I'm trying to have it match one text
parameter to two numbers or a range.


thanks,

 

[Dav]

Try

=sumproduct((K2:K20>=382)*(K2:K20<=383)*(E2:E20="x"))

Regards

Da

 

[Dav]

Try

=sumproduct((K2:K20>=382)*(K2:K20<=383)*(E2:E20="x"))

Regards

Da

 

[Guest]

=SUMPRODUCT(--(K2:K20>=382),--(K2:K20<=383),--(E2:E20="x"))

 

[Guest]

=SUMPRODUCT(--(K2:K20>=382),--(K2:K20<=383),--(E2:E20="x"))