| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
percentage something is done based on date
I want to track the number of times I do something each day in excel and get
a running percentage of the success rate. Easy example would be tracking what percentage of days I work out in the new year. I have the dates set up for the year, and have columns for things I want to track success rate on, but am lost after that. Any help is greatly appreciated. -- Nathan |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
percentage something is done based on date
One way:
B366: = COUNTA(B1:B365)/(TODAY()-DATE(2009,1,0)) In article , nfletch wrote: I want to track the number of times I do something each day in excel and get a running percentage of the success rate. Easy example would be tracking what percentage of days I work out in the new year. I have the dates set up for the year, and have columns for things I want to track success rate on, but am lost after that. Any help is greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limited value based on percentage of total | Excel Worksheet Functions | |||
| Calculate Percentage Based On Number | Excel Discussion (Misc queries) | |||
| How can I calculate commissions that are not percentage based? | Excel Discussion (Misc queries) | |||
| Calculate number based on percentage | Excel Worksheet Functions | |||
| Help with function to add percentage to cell based on checkbox. | Excel Worksheet Functions | |||
Linear Mode
