calculating the sum of the max 4values in 8 rows of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone,

Can anyone think of a good way of calculating the sum of the maximum four values in 8 rows of data within excel
eg if the values were 1,2,3,0,2,4,0,0 , the answer would be 11 (4+3+2+2

Alternatively is it possible to use 'sort' within a 'array' formula to generate another column with sorted data, whithin which its a simple calc to add the top 4 numbers

Cheer
Simmo
 
try this
=SUM(LARGE(B2:B7,{1,2,3,4}))

--
Don Guillett
SalesAid Software
(e-mail address removed)
Simmo said:
Hi Everyone,

Can anyone think of a good way of calculating the sum of the maximum four
Click to expand...
values in 8 rows of data within excel?
eg if the values were 1,2,3,0,2,4,0,0 , the answer would be 11 (4+3+2+2)

Alternatively is it possible to use 'sort' within a 'array' formula to
Click to expand...
generate another column with sorted data, whithin which its a simple calc to
add the top 4 numbers ?
 

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

Sum / Lookup 9
Calculate sum of values based on a ref value, how? 4
insert row when sum of values equals 100 3
An array formula to sum row max 2
Scrabble Value calculation for Welsh words 0
insert row when sum of values equals 100 2
summing part of data range 3
series of sums in a long spreadsheet 1

Back
Top