countif

C

Cryssie

Hi

I am wanting to count the number of cells in a range that
contain a value greater than X AND less than or equal to Y.
 
D

Dan E

=COUNTIF(A1:A100,">X")-COUNTIF(A1:A100,">Y")

Counts the number greater than X then subtracts the number
greater than Y leaving X<Val<=Y

OR

=SUMPRODUCT((A1:A100>X)*(A1:A100<=Y))

Dan E
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Excel Countif Function - Calculating Between Two Sets of Values 3
Countifs bites again 4
Sliding Commission Formula 2
Use TODAY() function as the criteria in a SUMIF formula 1
Excel Formula 2
Countif, index and match 2
Excel - count if a number falls within an array in a column & add 2

Top