Adding top 4 values

[kreases]

Hi,

I have a row of figures but only want to add the top four values, is there a simple formula to do this please, thanks

John

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1
2		16	27	21	23	14	28	18	18	3	12	17	6	20	14	8	22	3	20	13	29		107
3
Main

Cell Formulas
Range	Formula
W2	W2	=SUMIF(B2:U2,">="&LARGE(B2:U2,4))

 

[kreases]

That's exactly what I need, thanks

 

[Fluff]

Should have mentioned that if you can duplicate numbers, it may not work correctly.

 

[kreases]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1
2		16	27	21	23	14	28	18	18	3	12	17	6	20	14	8	22	3	20	13	29		107
3
Main

Cell Formulas
Range	Formula
W2	W2	=SUMIF(B2:U2,">="&LARGE(B2:U2,4))

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1
2		16	27	21	23	14	28	18	18	3	12	17	6	20	14	8	22	3	20	13	29		107
3
Main

Cell Formulas
Range	Formula
W2	W2	=SUMIF(B2:U2,">="&LARGE(B2:U2,4))

Should have mentioned that if you can duplicate numbers, it may not work correctly.

I have just noticed that, that will be an issue

 

[Fluff]

What version of Excel are you using?
Please update you account details to show this, as it affects which functions you can use.

 

[kreases]

What version of Excel are you using?
Please update you account details to show this, as it affects which functions you can use.

I have just updated that, says Microsoft Excel 2016 MSO 64 bit

 

[Fluff]

Thanks for that, how about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1
2		16	27	21	23	23	28	18	18	3	12	17	6	20	14	8	22	3	20	13	29		107
3
Main

Cell Formulas
Range	Formula
W2	W2	=SUM(AGGREGATE(14,6,B2:U2,ROW(1:4)))

 

[Eric W]

Or:

=SUM(LARGE(B2:U2,{1,2,3,4}))

 

[kreases]

Or:

=SUM(LARGE(B2:U2,{1,2,3,4}))

Yes that works thank you guys