Weekly data from a whole range

[Bazman170]

Not sure how to explain this but here goes.

I'm running a football score league and need to work out how to produce a league table for the individual week as an overall league. The overall league is sorted. But not sure how to get the information I need for the individual week as all data will be on one spreadsheet. Ideally I would just have to type in the relevant weeks number into B19 and all the info required would appear in the boxes A22 through to E22, likewise with weeks 2, 3 and onwards

A B C Weeks Baz James 1 6 1 1 4 3 1 0 5 1 3 0 1 2 6 2 6 1 2 1 2 2 0 4 2 3 0 2 5 0 3 6 1 3 6 1 3 3 2 3 2 1 3 1 1 Week: (B19) Games Exact Correct Extra Total A22 E22 <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

 

[arthurbr]

Haver you tried a Pivot Table?