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.
Bookmarks