# calculate the sum of the 5 lowest numbers.

1. ## calculate the sum of the 5 lowest numbers.

Dear All,
I have a list of numbers from A1 to H1- I nedd to calculate the sum of the 5 lowest numbers. can anybody help me.

ThankYou

Jessika  Register To Reply

2. Hi,

=SUM(SMALL(A1:H1,1),SMALL(A1:H1,2),SMALL(A1:H1,3),SMALL(A1:H1,4),SMALL(A1:H1,5))

should do it.  Register To Reply

3. ## Good afternoon Jessika

Next time you post, please try and use a title that reflects what you're asking.

In the meantime this formula should work for you.

=SUM(SMALL(A1:A8,{1,2,3,4,5}))
This is an array formula, so needs to be committed with Alt + Ctrl + Enter

HTH

DominicB  Register To Reply

4. ## Thank You

Thank You, it works!

Jessika  Register To Reply

5. Originally Posted by dominicb
This is an array formula, so needs to be committed with Alt + Ctrl + Enter
Hello Dominic,

In fact, you don't need CSE for that formula. Typically you don't when using an array constant [{1,2,3,4,5}], although you would if that array were calculated, i.e. this does require CSE

=SUM(SMALL(A1:A8,ROW(INDIRECT("1:5"))))  Register To Reply