Results 1 to 2 of 2

Count item based off month when it changes

Threaded View

  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.
    =COUNTIFS($N$3:$N$36,"="&A4)
    and then this on the "monthly stats" sheet
    =COUNTIFS('Ray Webber'!$M$3:$M$41,">"&1)
    . 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

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