Need Excel Formula to Sum

[aqeelnokia99]

we want to limit the number of cycles when doing that sum, if we say we just want to add up 3 cycles, then the formula should sum columns, W,T,Q

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Interval

Total

50​

53​

50​

53​

50​

53​

50​

53​

53​

53​

50​

53​

50​

53​

50​

53​

50​

53​

50​

53​

53​

53​

1​

1242​

50​

53​

50​

53​

50​

53​

50​

53​

100​

53​

50​

53​

50​

53​

50​

53​

50​

53​

50​

53​

100​

53​

2​

700​

32​

50​

234​

23​

50​

23​

21​

50​

50​

50​

50​

53​

32​

50​

234​

23​

50​

23​

21​

50​

50​

50​

3​

400​

24​

10​

12​

1​

50​

5​

10​

12​

10​

12​

50​

11​

24​

10​

12​

1​

50​

5​

10​

12​

10​

12​

6​

200​

5​

0​

100​

5​

0​

100​

5​

23​

100​

5​

24​

100​

5​

15​

100​

5​

10​

100​

10​

5​

100​

Period

3​

5​

0​

200​

10​

0​

300​

15​

23​

400​

20​

47​

500​

25​

62​

600​

30​

72​

700​

40​

77​

800​

Cycles

3​

30​

300​

 

[DanteAmor]

Try this:

Dante Amor
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1
2			Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Interval	Total
3			50	53	50	53	50	53	50	53	53	53	50	53	50	53	50	53	50	53	50	53	53	53	1	1242
4			50	53	50	53	50	53	50	53	100	53	50	53	50	53	50	53	50	53	50	53	100	53	2	700
5			32	50	234	23	50	23	21	50	50	50	50	53	32	50	234	23	50	23	21	50	50	50	3	400
6			24	10	12	1	50	5	10	12	10	12	50	11	24	10	12	1	50	5	10	12	10	12	6	200
7
8
9
10
11
12			5	0	100	5	0	100	5	23	100	5	24	100	5	15	100	5	10	100	10	5	100				Period	3
13			5	0	200	10	0	300	15	23	400	20	47	500	25	62	600	30	72	700	40	77	800				Cycles	3
14																						30	300
Hoja1

Cell Formulas
Range	Formula
V14	V14	=SUM(IF(MOD(COLUMN($C$12:$W$12),3)=1,IF(COLUMN($C$12:$W$12)>COLUMN($W$12)-($AB$13*3),$C$12:$W$12)))
W14	W14	=SUM(IF(MOD(COLUMN($C$12:$W$12),3)=2,IF(COLUMN($C$12:$W$12)>COLUMN($W$12)-($AB$12*3),$C$12:$W$12)))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[aqeelnokia99]

Try this:

Dante Amor
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1
2			Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Interval	Total
3			50	53	50	53	50	53	50	53	53	53	50	53	50	53	50	53	50	53	50	53	53	53	1	1242
4			50	53	50	53	50	53	50	53	100	53	50	53	50	53	50	53	50	53	50	53	100	53	2	700
5			32	50	234	23	50	23	21	50	50	50	50	53	32	50	234	23	50	23	21	50	50	50	3	400
6			24	10	12	1	50	5	10	12	10	12	50	11	24	10	12	1	50	5	10	12	10	12	6	200
7
8
9
10
11
12			5	0	100	5	0	100	5	23	100	5	24	100	5	15	100	5	10	100	10	5	100				Period	3
13			5	0	200	10	0	300	15	23	400	20	47	500	25	62	600	30	72	700	40	77	800				Cycles	3
14																						30	300
Hoja1

Cell Formulas
Range	Formula
V14	V14	=SUM(IF(MOD(COLUMN($C$12:$W$12),3)=1,IF(COLUMN($C$12:$W$12)>COLUMN($W$12)-($AB$13*3),$C$12:$W$12)))
W14	W14	=SUM(IF(MOD(COLUMN($C$12:$W$12),3)=2,IF(COLUMN($C$12:$W$12)>COLUMN($W$12)-($AB$12*3),$C$12:$W$12)))
Press CTRL+SHIFT+ENTER to enter array formulas.

Thanks you very very much

 

[DanteAmor]

Im glad to help you, thanks for the feedback.