View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Suddenly Stupid Suddenly Stupid is offline
external usenet poster
 
Posts: 1
Default Missing the trees for the forest...

I suspect this is a simple question for Excel 2003...

I need to take the highest 5 of 7 cells in a SUM function, or more to be
more concise, drop the two lowest cells and add the the top five.

I've been trying to SUMIF but I can't seem to get my criteria correct. I'll
happily wear the dunce hat for a day if someone can pass me the answer.