Ask Your Question
0

What is the formula to add two of the lowests numbers in a group of cells>

asked 2019-07-20 16:18:41 +0100

0for4 gravatar image

What is the formula to add two of the lowests numbers in a group of cells

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-07-20 17:30:45 +0100

0for4 gravatar image

=sum(small(b1:b4,1)+(small(b1:b4,2)))

edit flag offensive delete link more

Comments

The SUM in your solution is obsolete since it sums a single value, which already is the sum of two other values (+ already means: sum the values left and right to the operator)

=SUM(SMALL(B1:B4,1),SMALL(B1:B4,2)) -- or --
=SMALL(B1:B4,1) + SMALL(B1:B4,2)

Opaque gravatar imageOpaque ( 2019-07-20 17:42:03 +0100 )edit

Hi

If the number of cells to be added increases it may become interesting to use:

=SUMPRODUCT(SMALL($A$1:$A$10;ROW(A1:A2)))

Regards

pierre-yves samyn gravatar imagepierre-yves samyn ( 2019-07-21 07:59:08 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-20 16:18:41 +0100

Seen: 28 times

Last updated: Jul 20