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
|