Back for more help.

I have 8 rows with 8 different numbers (8 cells) and I want to add the four largest numbers into a cell any ideas

I have 8 rows with 8 different numbers (8 cells) and I want to add the four largest numbers into a cell any ideas

If you want to do with Excel formulaes, it simple

1. Sort the range in decending order.

2. Use the SUM Function to add the first four cells.

If you want to do in VBA, you can use the sort function as below:

Range(Cells(1, "B"), Cells(2, NumCount)).Sort Key1:=Cells(1, NumCount)

1. Sort the range in decending order.

2. Use the SUM Function to add the first four cells.

If you want to do in VBA, you can use the sort function as below:

Range(Cells(1, "B"), Cells(2, NumCount)).Sort Key1:=Cells(1, NumCount)

Hi Joe,

Assume that you 8 numbers are in C2:C9 and there is 1 pair of 7.

Assume that you 8 numbers are in C2:C9 and there is 1 pair of 7.

- Input this formula

- =LARGE($C$2:$C$9,1)&", "&LARGE($C$2:$C$9,2)&", "&LARGE($C$2:$C$9,3)&", "&LARGE($C$2:$C$9,4)
- You will get 8, 7, 7, 6
- attachment for you -->Fml_find4MaxNumbers.zip
Hope this help.

Pichart Y.

Hi Joe,

Or if you want to sum them, use this formula

Or if you want to sum them, use this formula

- =SUM(LARGE($C$2:$C$9,1),LARGE($C$2:$C$9,2),LARGE($C$2:$C$9,3),LARGE($C$2:$C$9,4))
- Sample attachment --> Fml_find4MaxNumbers.zip
Pichart Y.

Thank you for your help, have downloaded your sample, but alas not exactly what I need

So added a example, it might make it clearer what I want Help.zip

Again thanks for your help

So added a example, it might make it clearer what I want Help.zip

Again thanks for your help

Hi Joe,

please see this attachment -->Help_ans.zip

I have question...if there are 5 same largest number, will we sum only 4 ...or else please suggest..

pichart Y

please see this attachment -->Help_ans.zip

I have question...if there are 5 same largest number, will we sum only 4 ...or else please suggest..

pichart Y

only want to total 4 numbers, they could be the same,

Hi Joe Ryan,

So, the formula I provide in my last attachment is what you can use, please try it and let me know your feedback.

Remark: If the ranges of your data are always 8 lines, you can copy the formula to apply in all calculation cells.

Pichart Y.

So, the formula I provide in my last attachment is what you can use, please try it and let me know your feedback.

Remark: If the ranges of your data are always 8 lines, you can copy the formula to apply in all calculation cells.

Pichart Y.

Hi Pichart Y

Thanks alot, worked perfect, would your formula work if there were only 6 numbers ?

Thanks alot, worked perfect, would your formula work if there were only 6 numbers ?

Hi Joe,

You are welcome!!!

Yes!!, but...

You need to adjust the range in the formula....

You are welcome!!!

Yes!!, but...

You need to adjust the range in the formula....

That's all.

- From =SUM(LARGE(D3:D10,1),LARGE(D3:D10,2),LARGE(D3:D10,3),LARGE(D3:D10,4))
- to =SUM(LARGE(D3:D8,1),LARGE(D3:D8,2),LARGE(D3:D8,3),LARGE(D3:D8,4))

pichart Y.

Hi Pichart Y

Thanks alot, saved me a bunch of time.

Thanks alot, saved me a bunch of time.

Hi Joe,

You are welcome, see you here again.

Pichart Y.

You are welcome, see you here again.

Pichart Y.