Results 1 to 6 of 6

Function to Search COUNT

Threaded View

scubab Function to Search COUNT 12-07-2011, 02:58 PM
Special-K Re: Function to Search COUNT 12-09-2011, 11:03 AM
scubab Re: Function to Search COUNT 12-09-2011, 12:14 PM
dilipandey Re: Function to Search COUNT 12-10-2011, 07:35 AM
scubab Re: Function to Search COUNT 12-13-2011, 01:10 PM
dilipandey Re: Function to Search COUNT 12-13-2011, 01:37 PM
  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