sum of daily report with update worksheet everyday

[LeeVenter]

Good day,
Hi, I am newbie here, I found this forum might will help me with my limited skills on excel.
I am using Microsoft 2010.

The problem:

The worker will fill in/update the column Daily (C/S & KG) everyday.
and I need to make formula in the column Running Total (C/S & KG), it will be the sum of the dailies report.

I would need macro formula for this, but I just don't know how.

Can someone please help me?
I've been days figuring the formula out but still couldn't find it, so hopeless.

Thank you in advance!
Cheers!

 

[JamesCanale]

Mr Excel Playground 3.xlsm
	A	B	C	D
1	Daily		Running
2	CS	KG	CS	KG
3	10	24	10	24
4	22	17	32	41
5	22	21	54	62
6	5	15	59	77
7	22	6	81	83
8	9	20	90	103
9	20	14	110	117
10	17	21	127	138
11	15	6	142	144
12	19	11	161	155
Sheet29

Cell Formulas
Range	Formula
C3:D12	C3	=SUM(A$3:A3)

 

[LeeVenter]

hi JamesCanale!
Thank you for your quick reply!
I tried the formula on my sheet, it still doesn't work.

So the thing is, the worksheet will be with the worker, and they will using the same worksheet everyday to update the daily package (in the daily column)
And I want to Running Total columns calculate (sum) from the dailies update automatically, so the worker doesn't need to sum yesterdays package and todays package manually, they can just focus on the dailies report.

I hope you get what I mean.

Please help...

 

[JamesCanale]

I can't see how the formula above isn't doing that. It makes a running sum of whatever is put in columns A and B.

This modified one below can be put in the whole column (C and D)

Mr Excel Playground 3.xlsm
	A	B	C	D
1	Daily		Running
2	CS	KG	CS	KG
3	10	24	10	24
4	22	17	32	41
5	22	21	54	62
6	5	15	59	77
7	22	6	81	83
8	9	20	90	103
9	20	14	110	117
10	17	21	127	138
11	15	6	142	144
12	19	11	161	155
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Sheet29

Cell Formulas
Range	Formula
C3:D32	C3	=IF(ISNUMBER(A3),SUM(A$3:A3),"")

 

[LeeVenter]

I can't see how the formula above isn't doing that. It makes a running sum of whatever is put in columns A and B.

This modified one below can be put in the whole column (C and D)

Mr Excel Playground 3.xlsm
	A	B	C	D
1	Daily		Running
2	CS	KG	CS	KG
3	10	24	10	24
4	22	17	32	41
5	22	21	54	62
6	5	15	59	77
7	22	6	81	83
8	9	20	90	103
9	20	14	110	117
10	17	21	127	138
11	15	6	142	144
12	19	11	161	155
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Sheet29

Cell Formulas
Range	Formula
C3:D32	C3	=IF(ISNUMBER(A3),SUM(A$3:A3),"")

HI James,
It's perfect, it works!

But now the table is change as below:

The running total for each type, can it be automatically sum of everyday input?

Thanks once again!
Best regards,
Liana

 

[JamesCanale]

Something like this:

Mr Excel Playground 3.xlsm
	B	C	D	E	F	G	H	I	J	K	L
1						A		B		C
2		Daily		Running		Running		Running		Running
3	Package Type	CS	KG	CS	KG	CS	KG	CS	KG	CS	KG
4	A	10	24	10	24	10	24	0	0	0	0
5	B	22	17	32	41	10	24	22	17	0	0
6	C	22	21	54	62	10	24	22	17	22	21
7	B	5	15	59	77	10	24	27	32	22	21
8	C	22	6	81	83	10	24	27	32	44	27
9	A	9	20	90	103	19	44	27	32	44	27
10	A	20	14	110	117	39	58	27	32	44	27
11	B	17	21	127	138	39	58	44	53	44	27
12	A	15	6	142	144	54	64	44	53	44	27
13	C	19	11	161	155	54	64	44	53	63	38
14						54	64	44	53	63	38
15						54	64	44	53	63	38
16						54	64	44	53	63	38
17						54	64	44	53	63	38
18						54	64	44	53	63	38
19						54	64	44	53	63	38
20						54	64	44	53	63	38
21						54	64	44	53	63	38
22						54	64	44	53	63	38
23						54	64	44	53	63	38
24						54	64	44	53	63	38
25						54	64	44	53	63	38
26						54	64	44	53	63	38
27						54	64	44	53	63	38
28						54	64	44	53	63	38
29						54	64	44	53	63	38
30						54	64	44	53	63	38
31						54	64	44	53	63	38
32						54	64	44	53	63	38
33						54	64	44	53	63	38
34						54	64	44	53	63	38
35						54	64	44	53	63	38
Sheet29

Cell Formulas
Range	Formula
E4:F35	E4	=IF(ISNUMBER(C4),SUM(C$4:C4),"")
G4:G35,I4:I35,K4:K35	G4	=SUMPRODUCT($C$4:$C4,--($B$4:$B4=G$1))
H4,J4:J35,L4:L35	H4	=SUMPRODUCT($D$4:$D4,--($B$4:$B4=G$1))
H5:H35	H5	=SUMPRODUCT(D$4:D5,--($B$4:$B5=G$1))

 

[LeeVenter]

Something like this:

Mr Excel Playground 3.xlsm
	B	C	D	E	F	G	H	I	J	K	L
1						A		B		C
2		Daily		Running		Running		Running		Running
3	Package Type	CS	KG	CS	KG	CS	KG	CS	KG	CS	KG
4	A	10	24	10	24	10	24	0	0	0	0
5	B	22	17	32	41	10	24	22	17	0	0
6	C	22	21	54	62	10	24	22	17	22	21
7	B	5	15	59	77	10	24	27	32	22	21
8	C	22	6	81	83	10	24	27	32	44	27
9	A	9	20	90	103	19	44	27	32	44	27
10	A	20	14	110	117	39	58	27	32	44	27
11	B	17	21	127	138	39	58	44	53	44	27
12	A	15	6	142	144	54	64	44	53	44	27
13	C	19	11	161	155	54	64	44	53	63	38
14						54	64	44	53	63	38
15						54	64	44	53	63	38
16						54	64	44	53	63	38
17						54	64	44	53	63	38
18						54	64	44	53	63	38
19						54	64	44	53	63	38
20						54	64	44	53	63	38
21						54	64	44	53	63	38
22						54	64	44	53	63	38
23						54	64	44	53	63	38
24						54	64	44	53	63	38
25						54	64	44	53	63	38
26						54	64	44	53	63	38
27						54	64	44	53	63	38
28						54	64	44	53	63	38
29						54	64	44	53	63	38
30						54	64	44	53	63	38
31						54	64	44	53	63	38
32						54	64	44	53	63	38
33						54	64	44	53	63	38
34						54	64	44	53	63	38
35						54	64	44	53	63	38
Sheet29

Cell Formulas
Range	Formula
E4:F35	E4	=IF(ISNUMBER(C4),SUM(C$4:C4),"")
G4:G35,I4:I35,K4:K35	G4	=SUMPRODUCT($C$4:$C4,--($B$4:$B4=G$1))
H4,J4:J35,L4:L35	H4	=SUMPRODUCT($D$4:$D4,--($B$4:$B4=G$1))
H5:H35	H5	=SUMPRODUCT(D$4:D5,--($B$4:$B5=G$1))

Morning James!

Thank you so much! you are a STAR!

Cheers!
Liana