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-27-2018, 04:54 AM

NBVC

NBVC is offline

NBVC uses Windows 10

Windows 10 NBVC uses Office 2013

NBVC uses Office 2013

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC will become famous soon enough

Default

Is this it?

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

copied down

Reply With Quote