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
 
Back
Top