How do I keep a running total of people I contact as a percentage

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Query to see what percentage of people scored a specific number	John	Microsoft Access Queries	1	26th Apr 2010 03:44 PM
Percentage of total	=?Utf-8?B?Qk9PTkVS?=	Microsoft Access Queries	16	6th Sep 2006 02:32 PM
How do I keep a running total of pounds lost and percentage lost	=?Utf-8?B?YW5nZWw1OTU5?=	Microsoft Excel Misc	4	26th Jan 2006 09:18 PM
Percentage of Total	=?Utf-8?B?UnVzc0c=?=	Microsoft Access Queries	7	29th Mar 2005 08:41 PM
Percentage of total	=?Utf-8?B?RWRnYXIgVGhvZW1tZXM=?=	Microsoft Access Queries	1	4th Feb 2005 12:11 PM