Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sometimes you get too close to the tree to see the forest... | Excel Discussion (Misc queries) | |||
how to build Dependency Trees in Excel | Excel Discussion (Misc queries) | |||
Are there symbols for use in Excel to represent trees and plants? | Excel Discussion (Misc queries) | |||
Forest Plots......can these be done in excel or powerpoint | Charts and Charting in Excel | |||
telephone trees | Charts and Charting in Excel |