Microsoft Office Forums - View Single Post - Add best 6 numbers on a row of 10

Thread: Add best 6 numbers on a row of 10

View Single Post

Old

04-28-2018, 10:11 PM

Gyabaabonsu Gyabaabonsu is offline

Gyabaabonsu is offline

Gyabaabonsu uses Windows 7 64bit

Windows 7 64bit Gyabaabonsu uses Office 2013

Gyabaabonsu uses Office 2013

Office 2013

Novice

The original poster

Join Date: Apr 2018

Posts: 6

Gyabaabonsu is on a distinguished road

Default

Quote:

Originally Posted by NBVC

View Post

Is this it?

=SUMIF(A1:K1,"<="&SMALL(A1:K1,6))

copied down

Please It didn't work

Reply With Quote