Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum Function
I have a 32 Row (variable)10 column worksheet, each row
cell containing a number. The columns represent months and the number is inserted monthly. What I want to do is to add the highest 6 numbers out of the 10 on a rolling basis. I can't get my brain round this one !! Can antone help?? Tks Tom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum Function
Something like:
=Sum(Large(A2:Q2,{1,2,3,4,5,6})) This assumes you want the sum by row. Not sure where your numbers are, so adjust the range argument. -- Regards, Tom Ogilvy "TomD" wrote in message ... I have a 32 Row (variable)10 column worksheet, each row cell containing a number. The columns represent months and the number is inserted monthly. What I want to do is to add the highest 6 numbers out of the 10 on a rolling basis. I can't get my brain round this one !! Can antone help?? Tks Tom |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum Function
Here is a good start.
=SUM(LARGE(A1:A20,{1,2,3,4,5,6})) HTH, Merjet |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum Function
Tom,
This formula gives you the 6 largest in A1:J1 =SUM(LARGE(A1:J1,{1,2,3,4,5,6})) It's an array formula, so enter with Ctrl-Shift-Enter -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "TomD" wrote in message ... I have a 32 Row (variable)10 column worksheet, each row cell containing a number. The columns represent months and the number is inserted monthly. What I want to do is to add the highest 6 numbers out of the 10 on a rolling basis. I can't get my brain round this one !! Can antone help?? Tks Tom |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum Function
Gents,
To all who replied, many thanks for prompt response. Simple really, brain re-engaged. Thanks a lot. Tom -----Original Message----- I have a 32 Row (variable)10 column worksheet, each row cell containing a number. The columns represent months and the number is inserted monthly. What I want to do is to add the highest 6 numbers out of the 10 on a rolling basis. I can't get my brain round this one !! Can antone help?? Tks Tom . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |