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.
--
Hth
Kassie Kasselman
Change xxx to hotmail
"nfletch" wrote:
[Quoted Text] >
> 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
>
> --
>
> Nathan
|