year to date percentage

[drifted78]

sorry if this is a repeat i couldnt find excatly what i was lookinf for .
I have a sheet which shows the following

Month	Productivity
April	80%
May	82%
June	80%
July	84%
August	86%
September	87%
October	79%
November	83%
December	82%
January	92%
February	97% Is there a way to show a running yealy total in cell a30??

<tbody>
</tbody><colgroup><col><col></colgroup>

 

[123rickfear]

=sum(B:B)/count(B:B)

 

[jeffreybrown]

Why not just =AVERAGE(B:B)

 

[etaf]

you will not get an acurate ytd unless you know the volumes
if the volumes change significantly, for example

80% of 10 = 8
92% of 100 = 92

now the ytd of those is

100 out of 110
=91%

but the average of 80 and 92 = 86%