+ Reply to Thread
Results 1 to 2 of 2

Count item based off month when it changes

  1. #1
    Registered User
    Join Date
    11-29-2017
    Location
    Clearwater, FL
    MS-Off Ver
    2016
    Posts
    47

    Count item based off month when it changes

    I currently have a sheet called "Monthly Stats". It counts errors for each associate based off their sheet with their name on it. The sheet automatically puts the info in the correct month, based off the dates that are on the associates sheet in column A. In column E it counts the errors and this is the formula that I use on the associate's sheet.
    Please Login or Register  to view this content.
    and then this on the "monthly stats" sheet
    Please Login or Register  to view this content.
    . However it counts the 1 for all the months. What I need it to do, is look at the current month & count the errors for that month, when the date changes & goes to the next month, for it to keep the previous months data & start the new months error counts. I have attached an example work book for your reference. Thank you in advance for your help.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Count item based off month when it changes

    This is a massive sheet. I don't have the enthusiasm to wade through all of it to find these formulae. So... Exactly where are these formulae located? Remove any/all protection and repost.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help 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. [SOLVED] Filtering data based on few criteria such as month, style, item etc
    By Anuru in forum Excel Formulas & Functions
    Replies: 117
    Last Post: 06-11-2017, 01:36 PM
  2. Pick RANDOM item on the List based on the COUNT given
    By Jarvin24 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-01-2016, 08:44 AM
  3. [SOLVED] Count columns based on sum of previous month's row values once a value is hit
    By mnems in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-27-2015, 11:06 PM
  4. [SOLVED] Using SUMIFS to count the number of inquiries per month based on the date of inquiry
    By Tryin2Excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-25-2014, 04:11 AM
  5. Replies: 2
    Last Post: 01-30-2013, 03:16 AM
  6. macro to compare item based on month
    By koi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2012, 09:55 AM
  7. Taking the next item in a list into 1 of 2 tables based on the previous item time
    By SoleAris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2011, 04:59 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