Sum the 4 lowest numbers in a row of 7 numbers.

[robertd202]

I am trying to come up with a formula to sum the 4 lowest scores out of a row of 7. The purpose of this is to find the lowest scores in a best of 7 competition where there are 7 events, low score wins and you get the 3 highest scores thrown out. There should be a simple way to do this, but it eludes me.

[NBVC]

Try something like:

=SUM(SMALL(A2:G2,{1,2,3,4}))

where A2:G2 contain your 7 numbers.

[SteveG]

Hi,

Where A1:A7 are the scores try,

=SUM(IF(RANK(A1:$A$7,$A$1:$A$7,1)<=4,$A$1:$A$7,""))

This is an array formula so commit with Ctrl+Shift+Enter.

HTH
Steve

[robertd202]

Perfect. It works like a charm.