Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
percentage of success in item adjusted by date
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
percentage of success in item adjusted by date
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: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not a lottery success with Excel | Excel Worksheet Functions | |||
Can Excel reveal factors for success? | Excel Discussion (Misc queries) | |||
Determining football success.. | Excel Discussion (Misc queries) | |||
No Success with GetSaveAs | Excel Discussion (Misc queries) | |||
Custom formula to show each item as percentage of grand total? | Charts and Charting in Excel |