URGENT! how count how often a vlaue occurs within a range of value
Try one of these:
=COUNTIF(A1:J1,"=2")-COUNTIF(A1:J1,"=3")
Assuming the range will contain only numbers:
=SUMPRODUCT(--(INT(A1:J1)=2))
--
Biff
Microsoft Excel MVP
"elaine9412" wrote in message
...
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.
|