View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sarah
 
Posts: n/a
Default Adding data in a list that meets a specific criteria

Hi
I have a long column of data in descending order. I want to add up all the
data that fits a specific criteria e.g. all data below 10, then all data
between 10 and 20 etc etc. I have to repeat this often and the data set
changes regularly so I need to use a function rather than set ranges. Any
ideas?? Thanks!