View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel Bonallack Daniel Bonallack is offline
external usenet poster
 
Posts: 110
Default Sum largest numbers based on condition

I did a quick search for something I know has been asked many times before -
sorry to repost...

I need to sum the 5 largest numbers in column B where the year in column A
is equal to 2006

Thanks very much in advance (bob?)...