Thread: A row of values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Skip[_2_] Skip[_2_] is offline
external usenet poster
 
Posts: 29
Default A row of values

I have a row of 50 numericlical values. Some are positive other
negative.
Is there any way other than manually counting, I can determine
how many values are say greater than 4? Or how many values are
less than or equal to -2?
Any formula help will be much appreciated.
Thanks
Skip