Results 1 to 6 of 6

Function to Search COUNT

Threaded View

  1. #1
    Registered User
    Join Date
    08-20-2006
    Location
    USA
    MS-Off Ver
    MS Office 2010
    Posts
    37

    Function to Search COUNT

    Hello Everyone,
    My boss has tasked me with putting together a spreadsheet to track a certain task we perform. We track the customer's name and phone number and which of the two of us performed the task.
    I have set up COUNT statements to calculate individually, and collectively, how many times we've performed this task.
    Our boss wants to calculate on a monthly and weekly level and is okay manually counting each week, but I figured, if there was a way to make it easier for her, I would.
    Do you have any suggestions on a possible macro or function that could be used? I would like a way to enter the date range she is searching for.
    I've attached an example of our worksheet so far.
    Challenge TEST.xls
    Last edited by scubab; 12-09-2011 at 12:13 PM.

Thread Information

Users Browsing this Thread

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

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