Add best 6 numbers on a row of 10

		Microsoft Office Forums > Microsoft Excel > Excel
Add best 6 numbers on a row of 10

04-27-2018, 04:54 AM

NBVC

Windows 10 Add best 6 numbers on a row of 10

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Is this it?

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

copied down

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need Help Deleting Numbers in Hour Format and Numbers in Sequence	rsrasc	Word VBA	1	10-12-2016 02:49 PM
How do I edit my TOC to reference the section numbers instead of the page numbers???	mikey386	Word	0	12-17-2014 02:34 PM
Search a cell that contains words and numbers and convert the numbers to metric	Carchee	Excel Programming	36	10-08-2014 03:16 PM
How to change the formatting of numbers without changing the numbers?	sullengirl	Word	2	01-27-2014 03:06 PM
How do I refer to page numbers, when the numbers change as I prepare the document?	StevenD	Word	5	11-29-2012 12:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:01 PM.