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

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.
 
T

T. Valko

Try one of these:

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

Assuming the range will contain only numbers:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Excel - count if a number falls within an array in a column & add 2
Count function 7
return multiple values when within range (greater than and less than) 11
Count if equal to first non error cell 0
Excel Formula 2
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
A row of values 3

Top