+ Reply to Thread
Results 1 to 4 of 4

Total Contacts Within Date Range

  1. #1
    Registered User
    Join Date
    09-18-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    36

    Total Contacts Within Date Range

    I am trying to come up with a formula that will look at the table on the left and return the number of contacts each salesperson made each week on the table on the right. For instance, TWL made 43 contacts in the week starting 2/7/22 so that should show up in cell N7. I'm sure it's a fairly simple formula but for some reason my brain isn't working. Help, please!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,414

    Re: Total Contacts Within Date Range

    How about in H7 filled down & across
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-18-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Total Contacts Within Date Range

    Thanks! That worked perfectly!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,414

    Re: Total Contacts Within Date Range

    You're welcome & thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 06-19-2019, 09:28 AM
  2. Replies: 2
    Last Post: 03-03-2019, 02:50 AM
  3. Total manhours in date range
    By fmoiduf in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-08-2017, 05:32 PM
  4. Date and data lookup to total within a date range
    By greg123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-02-2016, 03:09 AM
  5. Replies: 8
    Last Post: 12-20-2015, 11:46 PM
  6. Replies: 3
    Last Post: 10-15-2015, 01:06 PM
  7. Not able to select multiple contacts to email from a Shared Contacts
    By champs in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 03-10-2009, 02:08 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1