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

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.

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.

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

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.

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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"elaine9412" wrote in message
...
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.