# how to insert formula to calculate average

#### kcube17

##### New Member
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>

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

What is the formula you use?

Is it YTD growth YoY?

What is the formula you use?

Is it YTD growth YoY?
its YTD growth. for example for A I want to give a target so that YTD Sep Growth will become 1% form -4%. there are thousands of rows like that so is there any formula to do it

I think this is more a math issue than excel.

In row A:

YTD Aug Gr is 4% --> 1 - (26/27) being 26 the YTD (Apr-Aug 14) and 27 the YTD (Apr-Aug 13)

Sep'14 --> (1 - YTD Sep Gr)*(YTD Apr-Sep 13)

thanks for rep but its nor working. what i want is if i put a number in sep'14, YTD Sep Gr should become 1% (5% increment over aug gr)

can you attach a file with the table, and in which cell you want the formula and what it should appear there?

You can't, but you can show small screen shots like I have here. My signature block below has several suggestions for how to do that and for where to test them.

See if this is what you want.

Excel Workbook
ABCDEFGHIJKLMNOPQ
1NamesApr'13May'13June'13July,13Aug'13Sep'13TotalApr'14May'14June'14July,14Aug'14Sep'14TotalYTD Aug GrYTD Sep Gr
2A15858734587158.3434.34-4%1%
3B25141518415257.4824.4831%36%
4C582328283285811.837.830%35%
5D45454527545456.729.75%10%
6E585158321585810.7637.7613%18%
7F6761267441267679.5247.523%8%
8G72828229282723.0724.07-22%-17%
9H87444734447879.4439.4411%16%
Target

can you attach a file with the table, and in which cell you want the formula and what it should appear there?

https://www.mediafire.com/?59zgw1f0eez9zqw

You can't, but you can show small screen shots like I have here. My signature block below has several suggestions for how to do that and for where to test them.

See if this is what you want.

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.34 34.34 -4% 1% 3 B 2 5 1 4 1 5 18 4 1 5 2 5 7.48 24.48 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.7 29.7 5% 10% 6 E 5 8 5 1 5 8 32 1 5 8 5 8 10.76 37.76 13% 18% 7 F 6 7 6 12 6 7 44 12 6 7 6 7 9.52 47.52 3% 8% 8 G 7 2 8 2 8 2 29 2 8 2 7 2 3.07 24.07 -22% -17% 9 H 8 7 4 4 4 7 34 4 4 7 8 7 9.44 39.44 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>

 Cell Formula H2 =SUM(B2:G2) N2 =SUM(\$B2:G2)*(P17+1.05)-SUM(\$I2:M2) O2 =SUM(I2:N2) P2 =(SUM(\$I2:M2)-SUM(\$B2:F2))/SUM(\$B2:F2) Q2 =(SUM(\$I2:N2)-SUM(\$B2:G2))/SUM(\$B2:G2)

<tbody>
</tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Thanks a lot. what is there in P17

Thanks a lot. what is there in P17
Sorry, that was a mistake
I'll try again.

Excel Workbook
ABCDEFGHIJKLMNOPQ
1NamesApr'13May'13June'13July,13Aug'13Sep'13TotalApr'14May'14June'14July,14Aug'14Sep'14TotalYTD Aug GrYTD Sep Gr
2A15858734587158.440734.441-4%1%
3B25141518415257.438524.43831%36%
4C582328283285811.837.830%35%
5D45454527545456.577329.5775%10%
6E585158321585810.637.613%18%
7F6761267441267679.389247.3893%8%
8G72828229282723.005624.006-22%-17%
9H87444734447879.477839.47811%16%
Target

Replies
6
Views
106
Replies
4
Views
109
Replies
1
Views
148
Replies
10
Views
112
Replies
1
Views
90

1,203,356
Messages
6,054,927
Members
444,759
Latest member
TeckTeck

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back