countif

  • Thread starter Thread starter Cryssie
  • Start date Start date
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.
 
=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

Excel Need Countifs Formula Help 0
Excel Formula 2
Excel - count if a number falls within an array in a column & add 3
COUNTIF....how to use >=0 but <9 as CRITERIA 3
count for numbers >one and < another in a row of cells 9
COUNTIF for 2 columns 6
Countif problem 2
Multiple logic tests 0

Back
Top