View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
elaine9412 elaine9412 is offline
external usenet poster
 
Posts: 6
Default 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.