+ Reply to Thread
Results 1 to 4 of 4

Count of restaurant checks for each day of a year

  1. #1
    Registered User
    Join Date
    01-31-2015
    Location
    St Paul
    MS-Off Ver
    2010
    Posts
    4

    Count of restaurant checks for each day of a year

    This should be easy, but I can't figure it out. Column A contains the numerical guest check number from a restaurant (unique to only one day. After midnight, the check numbering system resets), column B is the date of that guest check, so if there are 10 checks for 1/1/2017, there will be 10 rows, where column B will show 1/1/2017 in each of the rows. Apply the same logic to an entire year's worth of guest checks. I need to find out how many guest checks were rung up each day.

    I added column C which shows the dates of the year incrementing by 1. In column D I tried to add a formula that looks at the date from column C within column A, then returns the count of that day's guest checks from column B. No idea how to accomplish this. Any help much appreciated!
    Last edited by 6StringJazzer; 11-17-2017 at 02:23 PM. Reason: Provided meaningful title

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Can't believe this is so difficult!!!

    Upload sample file please. When dealing with dates, it is important for us to see what exactly is stored in the range.
    Ex: DateTime value but formatted as date. Text value that looks like date value. etc.

    Or you can just use pivot table to summarize data, instead of using formula.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,720

    Re: Count of restaurant checks for each day of a year

    Try this in column D, assuming your data starts on row 2:

    =COUNTIF(B:B,C2)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Registered User
    Join Date
    01-31-2015
    Location
    St Paul
    MS-Off Ver
    2010
    Posts
    4

    Re: Count of restaurant checks for each day of a year

    I'm under a time crunch, so I went with the pivot table solution. Thanks for replying so quickly, both of you. :-)

+ 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. it's difficult
    By ky4068 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2014, 10:08 AM
  2. Replies: 2
    Last Post: 12-20-2013, 12:12 AM
  3. Difficult look up help
    By floricita in forum Excel General
    Replies: 19
    Last Post: 10-05-2012, 07:35 AM
  4. Help, too difficult for me.
    By Menno in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-19-2006, 09:53 AM
  5. Difficult but do-able?
    By Jaydubs in forum Excel General
    Replies: 8
    Last Post: 10-06-2005, 06:05 AM
  6. Is this difficult???
    By mingolo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2005, 02:05 PM
  7. Ok I have to be difficult
    By Dominique Feteau in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-26-2005, 01:05 PM

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