Soma mensal acumulada / Accumulated Monthly Sum

[asampaio]

Hi, all
Please support me.
I provided the spreadsheet in english and portuguese languages as you wish.
Many thanks for those that are interested on the solution of this issue.

Regards,
Albert

Soma Mensal Acumulada_Accumulated Monthly Sum.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
2	Year	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2023	2023	2023	2023	2023
3	Month	Oct	Oct	Oct	Oct	Nov	Nov	Nov	Nov	Dec	Dec	Dec	Dec	Dec	Jan	Jan	Jan	Jan	Feb
4	Week	W40	W41	W42	W43	W44	W45	W46	W47	W48	W49	W50	W51	W52	W1	W2	W3	W4	W5
5	Week Start Date	10/3~	10/10~	10/17~	10/24~	10/31~	11/7~	11/14~	11/21~	11/28~	12/5~	12/12~	12/19~	12/26~	1/2~	1/9~	1/16~	1/23~	1/30~
6	Qty	3000	85120	34048	21888	9728	41344	31616	26752	2432	12160	7296	29184	29184	53504	41344	43776	55936	43776
7	Accumulated Qty per month	3000	88120	122168	144056	9728	51072	82688	109440	2432	14592	21888	51072	80256	53504	94848	138624	194560	238336
8
9
10	Remarks:
11	Please develop the formula for the range C7:T7, according to the results above (marked in yellow cells).
12	Please consider that the dates (range C2:T5) will be changed eventually, and the quantities (range C6:T6); so the fomula in the range C7:T7 must becapable to calculate automatically.
13	If possible, try to avoid matricial formula. If not possible, please provide your best solution.
English

Cell Formulas
Range	Formula
C2:T2	C2	=YEAR(C5)
C3:T3	C3	=TEXT(DATE(,MONTH(C5+3),1),"[$-en-US]mmm;@")
D5:T5	D5	=+C5+7

Soma Mensal Acumulada_Accumulated Monthly Sum.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
2	Ano	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2022	2023	2023	2023	2023	2023
3	Mês	Oct	Oct	Oct	Oct	Nov	Nov	Nov	Nov	Dec	Dec	Dec	Dec	Dec	Jan	Jan	Jan	Jan	Feb
4	Semana	W40	W41	W42	W43	W44	W45	W46	W47	W48	W49	W50	W51	W52	W1	W2	W3	W4	W5
5	Data inicial da semana	10/3~	10/10~	10/17~	10/24~	10/31~	11/7~	11/14~	11/21~	11/28~	12/5~	12/12~	12/19~	12/26~	1/2~	1/9~	1/16~	1/23~	1/30~
6	Qtde	3000	85120	34048	21888	9728	41344	31616	26752	2432	12160	7296	29184	29184	53504	41344	43776	55936	43776
7	Qtde Acumulada por mês	3000	88120	122168	144056	9728	51072	82688	109440	2432	14592	21888	51072	80256	53504	94848	138624	194560	238336
8
9
10	Observações:
11	Por favor desenvolva uma fórmula para o intervalo C7:T7 de acordo com os resultados acima (células em amarelo).
12	Por favor considere que as datas (intervalo C2:T5) serão manualmente alteradas eventualmente, bem como as quantidades (intervalo C6:T6); então a fórmula do intervalo C7:T7 deve ser capaz de calclar automaticamente.
13	Se for possível, evite fórmula matricial. Caso contrário, por favor dê sua melhor solução.
Portuguese

Cell Formulas
Range	Formula
C2:T2	C2	=YEAR(C5)
C3:T3	C3	=TEXT(DATE(,MONTH(C5+3),1),"[$-en-US]mmm;@")
D5:T5	D5	=+C5+7

 

[Leo Skywalker]

Hi there,

Why is the accumulated in February 2023 (cell T6) 238336?, I guess it should be 43776.

If it is a mistake, then try this in C7:

=IF(C3<>B3,C6,C6+B7)

Then copy to the right.
It just checks when there is a change of month and if so starts over adding the accumulated quatities.

 

[asampaio]

Hi there,

Why is the accumulated in February 2023 (cell T6) 238336?, I guess it should be 43776.

If it is a mistake, then try this in C7:

=IF(C3<>B3,C6,C6+B7)

Then copy to the right.
It just checks when there is a change of month and if so starts over adding the accumulated quatities.

Dear @Leo Skywalker . I deeply appreciate your support on this thread. About cell T6, it was a typo. Your solution works perfectly. Thank you so much.