With
A1:H8 containing randomly dispersed numbers and blanks

This formula returns the sum of the 5 highest numbers in that range
=SUM(LARGE(A1:H8,{1,2,3,4,5}))

Note: if there may be less than 5 numbers overall let us know so we can trap
that (with a more complicated formula).

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


" wrote:

Hi,

I have to add up the highest 5 numbers from a series of 8 columns.
Some rows will have 5 different numbers, some 6, some 7 or 8. Is there
a way to find the 5 highest from that series, and then have another
equation to add them up?

Thanks,

Mark