how to insert formula to calculate average

[kcube17]

hi
I have months in rows and names in columns. apr to sep achievement last and apr to aug achievement this year. now i want to give a target for september so that the year till date (YTD sep) growth will be 5% more than YTD Growth of aug. I am unable to find a formula. please help

Names	Apr'13	May'13	June'13	July,13	Aug'13	Sep'13	Total	Apr'14	May'14	June'14	July,14	Aug'14	Sep'14	Total	YTD Aug Gr	YTD Sep Gr
A	1	5	8	5	8	7	34	5	8	7	1	5		26	-4%	-24%
B	2	5	1	4	1	5	18	4	1	5	2	5		17	31%	-6%
C	5	8	2	3	2	8	28	3	2	8	5	8		26	30%	-7%
D	4	5	4	5	4	5	27	5	4	5	4	5		23	5%	-15%
E	5	8	5	1	5	8	32	1	5	8	5	8		27	13%	-16%
F	6	7	6	12	6	7	44	12	6	7	6	7		38	3%	-14%
G	7	2	8	2	8	2	29	2	8	2	7	2		21	-22%	-28%
H	8	7	4	4	4	7	34	4	4	7	8	7		30	11%	-12%

<colgroup><col span="7"><col><col span="6"><col><col><col></colgroup><tbody>
</tbody>

 

[kcube17]

Sorry, that was a mistake
I'll try again.

Target

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Names	Apr'13	May'13	June'13	July,13	Aug'13	Sep'13	Total	Apr'14	May'14	June'14	July,14	Aug'14	Sep'14	Total	YTD Aug Gr	YTD Sep Gr
2	A	1	5	8	5	8	7	34	5	8	7	1	5	8.4407	34.441	-4%	1%
3	B	2	5	1	4	1	5	18	4	1	5	2	5	7.4385	24.438	31%	36%
4	C	5	8	2	3	2	8	28	3	2	8	5	8	11.8	37.8	30%	35%
5	D	4	5	4	5	4	5	27	5	4	5	4	5	6.5773	29.577	5%	10%
6	E	5	8	5	1	5	8	32	1	5	8	5	8	10.6	37.6	13%	18%
7	F	6	7	6	12	6	7	44	12	6	7	6	7	9.3892	47.389	3%	8%
8	G	7	2	8	2	8	2	29	2	8	2	7	2	3.0056	24.006	-22%	-17%
9	H	8	7	4	4	4	7	34	4	4	7	8	7	9.4778	39.478	11%	16%

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:56px;"><col style="width:53px;"><col style="width:53px;"><col style="width:53px;"><col style="width:53px;"><col style="width:53px;"><col style="width:53px;"><col style="width:53px;"><col style="width:53px;"><col style="width:53px;"><col style="width:53px;"><col style="width:53px;"><col style="width:53px;"><col style="width:53px;"><col style="width:53px;"><col style="width:93px;"><col style="width:111px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula N2 =SUM($B2:G2)*(P2+1.05)-SUM($I2:M2) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

thanks its working

 

[Peter_SSs]

thanks its working

Thanks for letting us know.