# 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

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.

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

4. ## Thank You

Thank You, it works!

Jessika

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"))))

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1