Friday, June 13, 2014

yogi_Compute Total Number Of Names As Well As Number Of Unique Names Contacted By MonthToDate


                                         Google Spreadsheet   Post  #1670
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-13-2014
post by C_Myers: (https://productforums.google.com/forum/#!mydiscussions/docs/5_E6JtBOe_8)
How do I determine a month to date total each week without the previous MTDtotal changing?
'm tracking the number of people contacted daily and weekly each month.  There are 128 people, many will have multiple contacts throughout the month.  We have been marking a "1" in the cell corresponding to the person and date which is fine for calculating sum totals.  What is the best way to determine a month to date total each week of the different people contacted? 

For example, at the end of week 1 I need the total of different people contacted (How many out of 128).  At the end of week two I need the total of different people contacted for weeks 1 and 2...and so on.  How do I do this without effecting the MTD total for previous weeks?  I've attached an excel file for reference but the contact data has been deleted for privacy.  Any help is greatly appreciated.
Attachments (1)

Call Tracker.xlsx
34 KB   View   Download
---