URGENT! how count how often a vlaue occurs within a range of value

  • Thread starter Thread starter elaine9412
  • Start date Start date
E

elaine9412

What formulae do I use to count how may times a number equal to and greater
than 2 but less than 3 occurs in one row? ( I have numbers in the row that
are a mix of 1, 2, 2.5, 2.75, 3 etc).
I have tried many ways and it is not working - I appreciate your expert help.
 
Try one of these:

=COUNTIF(A1:J1,">=2")-COUNTIF(A1:J1,">=3")

Assuming the range will contain only numbers:

=SUMPRODUCT(--(INT(A1:J1)=2))
 
Back
Top