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).

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).

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).