perfect the first option worked - you are a life saver:)

"T. Valko" wrote:

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.