OK a few points...
First change the formulae you're using in your Summary section - as is you're storing numbers as text which is only going to cause you problems:
'Sheet 2'!B54: =AVERAGE(K:K)
copy across to H54
For presentation purposes set cell format of B54:H54 to Percentage (to 2 decimals)
Then to keep things simple... assuming "1 day" etc always appears in Column B on Sheet 2 and values are always in row below then use this logic to determine your remaining calcs - store this value in any given cell (to avoid repetitive calcs), eg:
'Sheet 1'!$F$1: =MATCH("Day 1",'Sheet 2'!$B:$B,0)+1
Your remaining calcs are then pretty straightforward I think...
2 day
'Sheet 1'!$B$7: =SUM(INDEX('Sheet 2'!$B:$C,$F$1,0))
4 day
'Sheet 1'!$C$7: =SUM(INDEX('Sheet 2'!$B:$E,$F$1,0))
Bookmarks