percentage of success in item adjusted by date

[nfletch]

I am trying to figure out how to track the overall percentage of times
something is done each day and have it automatically adjust each day with
date function throughout the year. For example, if i wanted to track the
percentage of days i worked out in the new year. In an excel sheet already
set up with dates for the entire year and a column for work out, how can i
see the percentage of times i enter a 1 for that date having it adjusted each
day?

Thanks

 

[Kassie]

Your question is quite ambiguous? Do you want to calculate the percentae of
days that something happens, or do you want to calculate a percentage of how
many times per day, over a period of 1 year, that something happens?
Considering your example of determining the percentage of days per year that
you have practiced, I take it that it is number 1?

If that is the case, then with your dates in Col A, say from A1:A365, use
Col B, B1:B365, to enter the 1's next to those dates when you practice. In
another cell, eg. in C1, enter the following formula:
=SUM(B1:B365)*100/365

Freeze panes on the sheet so that row 1 always remains visible, and every
time you insert a 1 in Col B, next to a date in Col A, your percentage will
adjust. To freeze panes, simply select cell A1, and then select View, Freeze
panes.