Hello everyone.

I'm fairly new to the programming side of Excel, but am slowly picking it up!

I have a question, hopefully you will be able to help. I need to know how I can create a formula which will sum a selection of the highest numbers in a range of data. So for example, if I have a row of 10 cells each containing dfferent numbers, and I want to take the 7 highest values from there and get the sum of these values, how do I go about this?

I've tried using the LARGE command but can only get an individual figure, can someone please point me in the right direction?

Thanks all,

Roy K.