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

U

uptight26

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

Sheeloo

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
 
D

David Biddulph

=COUNT(daterange)/COUNTA(namerange)
or =COUNT(daterange)/67
Format as percentage.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
How do I clear a form? 0
Simple (maybe) percentage forumla 5
Percentages 2
Using <= in countifs statement 1
Linking Checkboxes/Drop Down Lists to a Formula 4
Calculate / Report Total Project Resource Percentage 0
how to return "summary" of all non-blank cells plus their headers 10

Top