Average Year-to-Date of percentages

[techgirl]

I will eventually have 12 months, each month being a percentage. What would the formula be to calculate the average year-to-date?? Right now I only have 7 months...
Jan=30%
Feb=13%
Mar=40%
Apr=14%
May=15%
Jun=21%
Jul=20%

If I use sum(D1:J1)/12 I receive 13% YTD. Is this correct or should I use the =Average(D1:J1); if so I receive 22% YTD.

??
Thanks, Techgirl

 

[Yahya]

use Average is better than sum then divide on 12
in your data you have just 7 months

try this
<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Jan</td><td style="text-align: right;;">30%</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">Feb</td><td style="text-align: right;;">13%</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">Mar</td><td style="text-align: right;;">40%</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">Apr</td><td style="text-align: right;;">14%</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">May</td><td style="text-align: right;;">15%</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">Jun</td><td style="text-align: right;;">21%</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">Jul</td><td style="text-align: right;;">20%</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">AVERAGE</td><td style="text-align: right;;">22%</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;"></td><td style="text-align: right;;">22%</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet2</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B9</th><td style="text-align:left">=AVERAGE(<font color="Blue">B1:B7</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B10</th><td style="text-align:left">=SUM(<font color="Blue">B1:B7</font>)/COUNT(<font color="Blue">B1:B7</font>)</td></tr></tbody></table></td></tr></table><br />

 

[techgirl]

So the "Average" formula will give me the most accurate answer to give me a RUNNING YTD total, no matter if I have 7, 9 or 12 months of data??