YTD PERCENTAGE

Closed
D - Feb 18, 2010 at 02:53 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 18, 2010 at 04:47 PM
Hello,

I am doing a fiscal year productivity report that I submit monthly. I currently have a column w/YTD numbers for work hours and the director wwould like to see a YTD percent total.

Is this the formula



=AVERAGE(A2:A6)

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 18, 2010 at 04:47 PM
Well this will give you one figure of the average over the year.

YTD percent total to me suggest you boss wants to see for each cycle whats %age counts towards yearly total
more like
=a2/sum(a2:a6) * 100

Better clarify with boss
0