View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dan B Dan B is offline
external usenet poster
 
Posts: 60
Default add numbers if they meet criteria...?

Hi,

I have a column of numbers. I need a formula that will look at the whole
range and add up only the numbers that are 50 or less. Then I need another
formula that will add them if they are 51 or more.

Thanks for the help.