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