Hi Mr Excel
I run a small business, where I have a few employees.
I want to create a timesheet, where the weeks are divided into seperate sheets and in the end i have a aggregated sheet.
I need a formula that can aggregate all x, y and z seperately from the week into my aggregated sheet.
i will try to illustrate my problem below
Customer Monday Tuesday Wed .... Aggregated
1001 4 2 1 7
1002 3 2 3 8
1001 1 1 1 3
Aggregated for: 1001 = 10
1002 = 8
I need a formula to aggregate all 1001, 1002 etc..
I run a small business, where I have a few employees.
I want to create a timesheet, where the weeks are divided into seperate sheets and in the end i have a aggregated sheet.
I need a formula that can aggregate all x, y and z seperately from the week into my aggregated sheet.
i will try to illustrate my problem below
Customer Monday Tuesday Wed .... Aggregated
1001 4 2 1 7
1002 3 2 3 8
1001 1 1 1 3
Aggregated for: 1001 = 10
1002 = 8
I need a formula to aggregate all 1001, 1002 etc..