Searching for the lowest 3 numbers

RobMcKee · Apr 10th, 2002, 04:39 PM

I have 5 columns of non-sequential numbers and I would like to be able to pull out the lowest three numbers and sum them in one cell.

Can this be done?

Mark W. · Apr 10th, 2002, 04:41 PM

=SUM(SMALL(range,{1,2,3})

Dave Patton · Apr 10th, 2002, 04:55 PM

=SUM(SMALL(E2:I6,{1,2,3}))

or just

=SMALL(E2:I5,1)+SMALL(E2:I5,2)+SMALL(E2:I5,3)

Revise the references as necessary.

RobMcKee · Apr 10th, 2002, 05:00 PM

Thanks very much to both of you!!

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

Apr 10th, 2002, 04:39 PM	#1
RobMcKee New Member Join Date: Apr 2002 Posts: 8	I have 5 columns of non-sequential numbers and I would like to be able to pull out the lowest three numbers and sum them in one cell. Can this be done?

Apr 10th, 2002, 04:41 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=SUM(SMALL(range,{1,2,3})

Apr 10th, 2002, 04:55 PM	#3
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	=SUM(SMALL(E2:I6,{1,2,3})) or just =SMALL(E2:I5,1)+SMALL(E2:I5,2)+SMALL(E2:I5,3) Revise the references as necessary.

Apr 10th, 2002, 05:00 PM	#4
RobMcKee New Member Join Date: Apr 2002 Posts: 8	Thanks very much to both of you!!