| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Missing the trees for the forest...
=SUM(LARGE(A1:A7,{1,2,3,4,5}))
-- Regards, Peo Sjoblom "Suddenly Stupid" <Suddenly wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Missing the trees for the forest...
On Nov 27, 10:29 am, Suddenly Stupid <Suddenly
wrote: 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. I use the Large() function if it si only five. Large(Your Array, 1) + Large(Your Array,2) .....Cont. to 5. This way no matter how large your list gets, this will continue to work. Jay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
