Use a variable as a sum factor.

[Holst]

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..

 

[Oeldere]

Maybe this way.

Excel Workbook
	A	B	C	D	E
1	Customer	Monday	Tuesday	Wed	Aggregated
2	1001	4	2	1	7
3	1002	3	2	3	8
4	1001	1	1	1	3
5
6
7
8	1001	5	3	2	10
9	1002	3	2	3	8
Blad1

Cell Formulas
Range	Formula
B8	=SUMPRODUCT(($A$2:$A$6=$A8)*(B$2:B$6))
B9	=SUMPRODUCT(($A$2:$A$6=$A9)*(B$2:B$6))
C8	=SUMPRODUCT(($A$2:$A$6=$A8)*(C$2:C$6))
C9	=SUMPRODUCT(($A$2:$A$6=$A9)*(C$2:C$6))
D8	=SUMPRODUCT(($A$2:$A$6=$A8)*(D$2:D$6))
D9	=SUMPRODUCT(($A$2:$A$6=$A9)*(D$2:D$6))
E8	=SUMPRODUCT(($A$2:$A$6=$A8)*(E$2:E$6))
E9	=SUMPRODUCT(($A$2:$A$6=$A9)*(E$2:E$6))

 

[West Man]

Try in B8 dragged across and down: =SUMIF($A$2:$A$4,$A8,B$2:B$4)