summing part of data range

R

Roy Gudgeon

Hi Guys

I have a spreadsheet with 8 columns of data and multiple rows
For each row I want to sum the 7 highest values in the range of 8 values.

Cna anyone advise the function/formula/syntax i need to use ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Indenting every other paragraph in Word at the same time? 0
use xlup and offset in a range of cells 1
Copy addition formula of non-consecutive horizontal cells 2
Creating a Chart on form from selected data in query. 0
Finding largest total of ANY two values in a data set 6
Getting Text data using the Data - Subtotal feature 1
Summing rows using formulas with variables 2

Top