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
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
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.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
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
Please familiarise yourself with the rules before posting. You can find them here.
Thank You, it works!
Jessika
Hello Dominic,Originally Posted by dominicb
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"))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks