i have a bracket spreadsheet and need help calculating results

[dziedzje]

i'm running a pool (i know not a standard issue lol) and i have a list of golfers on the left column, and a list of people on the top. the second column is the golfers score. under each persons name (bracket entry) they select a bunch of golfers which are signaled by an x in the cell. the 5 lowest scores (you can select more people but the only thing that gets tallied up are the 5 lowest scores) get totaled up under your name. does anyone have a way that can look under your name see all the x's you have and cross reference column 2 with scores and total up the 5 lowest scores???? this may be difficult or not possible but i'm open to suggestions. Thank you!!!

i attached a sample of the pool

[dziedzje]

i'm lookin for the impossible but i'm sure someone can figure out this issue or even a better way to track and autocalculate this information!!!! Thank you all

[Sam Capricci]

you could use a filter on row 1, then select "x" and you'll see those for each participant.

EDIT: nevermind, I see you also want the 5 lowest too.

[Tony Valko]

Try this...

G1 = some name

This array formula** entered in G2:

=SUM(SMALL(IF(INDEX(C4:E53,0,MATCH(G1,C1:E1,0))="x",B4:B53),{1,2,3,4,5}))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[Tony Valko]

On a side note...

You might want to change the thread title to something more specific like:

Sum lowest 5 scores that correspond to "X"

The forum owner doesn't like ambiguous thread titles.