+ Reply to Thread
Results 1 to 4 of 4

Counting number of occurrences in a given month

  1. #1
    Registered User
    Join Date
    12-17-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Counting number of occurrences in a given month

    I have a spread sheet that tracks the number of sign ups for my small business. I'm trying to get a COUNT of the number of sales in each month and I'm trying to figure out the way to COUNTIF with the sale happening between the first and last month of each day, but can't figure how to code that correctly.

    Any ideas?

    Thanks

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Counting number of occurrences in a given month

    Hi and welcome to the forum

    To do a count basedd on more that 1 criteria (as in between this date and that date) you need to use countifS(), not couuntif()
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  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,532

    Re: Counting number of occurrences in a given month

    See attached example. Note that the data for each month is actually a date, formatted as a month and year.

    BTW
    Quote Originally Posted by tief10 View Post
    ...between the first and last month of each day...
    I'm pretty sure you meant between the first and last day of each month....
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Counting number of occurrences in a given month

    Find enclosed Jeff's solution extended with # of units sold each month. SUMIFS function is used in this case.
    Attached Files Attached Files
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang

+ 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. Counting the number of occurrences and spanning midnight
    By allwrighty in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-01-2013, 05:53 PM
  2. Counting occurrences within each month
    By Fatosi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-14-2012, 04:26 PM
  3. Counting number of occurrences in a list
    By timtrag12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2010, 05:31 PM
  4. Counting number occurrences
    By thermometer in forum Excel General
    Replies: 3
    Last Post: 06-06-2006, 03:10 PM
  5. Counting number of occurrences
    By LyleB_Austin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-15-2005, 06:05 PM

Tags for this Thread

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