YTD total basis month and Particular Headers Criteria in Grand Total

[chaitus27]

[TABLE="width: 626"]
<colgroup><col><col span="7"><col span="2"><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD="colspan: 3"]APR[/TD]
[TD="colspan: 2"]MAY[/TD]
[TD="colspan: 2"]JUN[/TD]
[TD="colspan: 3"]GRAND TOTAL[/TD]
[/TR]
[TR]
[TD]PARTICULARS[/TD]
[TD]ACT'18[/TD]
[TD] AOP'19[/TD]
[TD] ACT'19[/TD]
[TD] ACT'18 [/TD]
[TD]AOP'19[/TD]
[TD] ACT'18 [/TD]
[TD]AOP'19[/TD]
[TD] ACT'18 [/TD]
[TD]AOP'19[/TD]
[TD] ACT'19[/TD]
[/TR]
[TR]
[TD] SEATS [/TD]
[TD] 10[/TD]
[TD] 8[/TD]
[TD] 7[/TD]
[TD] 5[/TD]
[TD] 6[/TD]
[TD] 4[/TD]
[TD] 5[/TD]
[TD] 19[/TD]
[TD] 19[/TD]
[TD] 7[/TD]
[/TR]
[TR]
[TD] AGENTS [/TD]
[TD] 15[/TD]
[TD] 12[/TD]
[TD] 11[/TD]
[TD] 8[/TD]
[TD] 7[/TD]
[TD] 6[/TD]
[TD] 7[/TD]
[TD] 29[/TD]
[TD] 26[/TD]
[TD] 11[/TD]
[/TR]
[TR]
[TD] CALLS [/TD]
[TD] 1,100[/TD]
[TD] 900[/TD]
[TD] 800[/TD]
[TD] 600[/TD]
[TD] 650[/TD]
[TD] 450[/TD]
[TD] 600[/TD]
[TD] 2,150[/TD]
[TD] 2,150[/TD]
[TD] 800[/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

Copy formula down and across as needed.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1		APR			MAY		JUN		GRAND TOTAL
2	PARTICULARS	ACT'18	AOP'19	ACT'19	ACT'18	AOP'19	ACT'18	AOP'19	ACT'18	AOP'19	ACT'19
3	SEATS	10	8	7	5	6	4	5	19	19	7
4	AGENTS	15	12	11	8	7	6	7	29	26	11
5	CALLS	1,100	900	800	600	650	450	600	2150	2150	800
Sheet

 

[chaitus27]

Dear Ahoy,

Thanks for your quick reply, however i want a YTD formula with subsequent month getting added automatically as the month gets changed, please help me

 

[AhoyNC]

How are you adding the new months?
Are you inserting them before the Grand Total columns using insert column or some other method? Does the first month all ways start at the same column (as in my example above would the first month always be in column B)?