Thread: URGENT! how count how often a vlaue occurs within a range of value
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default 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.





Reply With QuoteReply With Quote