| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I keep a running total of people I contact as a percentage
I need to keep a running tally of people that I contact from a speicific list
(a total of 67 people) and I need to display it as a percentage. I would like to use the date that I contacted them as a reference (I place the date contacted in a field). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I keep a running total of people I contact as a percentage
If you enter the date in Col B when you contact them and leave it blank
otherwise then you can have this in any cell (assuming first row had headers and your data dates are in B2-B68) =COUNTIF(B2:B68,"<")/ROWS(B2:B68) or =COUNTIF(B2:B68,"<")/67 and format as percentage "uptight26" wrote: I need to keep a running tally of people that I contact from a speicific list (a total of 67 people) and I need to display it as a percentage. I would like to use the date that I contacted them as a reference (I place the date contacted in a field). |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I keep a running total of people I contact as a percentage
=COUNT(daterange)/COUNTA(namerange)
or =COUNT(daterange)/67 Format as percentage. -- David Biddulph "uptight26" wrote in message ... I need to keep a running tally of people that I contact from a speicific list (a total of 67 people) and I need to display it as a percentage. I would like to use the date that I contacted them as a reference (I place the date contacted in a field). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
| running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
| How do I keep a running total of pounds lost and percentage lost | Excel Discussion (Misc queries) | |||
| HOW DO I CALCULATE A RUNNING PERCENTAGE | Excel Discussion (Misc queries) | |||
Linear Mode
