I have a spread sheet with staff names in column A and their weekly targets for the year (52 weeks) running across the rest of the spreadsheet B:BA
Example
A1 B1 C1 D1 ----> BA1
Jon 10 8 16
Max 8 14 12
Is there a smiple way of creating a table showing the cumulative weekly targets for each staff member in column BC onwards?
Example
BC1 BD1 BE1 BF1
Jon 10 18 34
Max 8 22 34
Example
A1 B1 C1 D1 ----> BA1
Jon 10 8 16
Max 8 14 12
Is there a smiple way of creating a table showing the cumulative weekly targets for each staff member in column BC onwards?
Example
BC1 BD1 BE1 BF1
Jon 10 18 34
Max 8 22 34
