+ Reply to Thread
Results 1 to 3 of 3

Combining multiple COUNTIFS for monthly totals

  1. #1
    Registered User
    Join Date
    09-27-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    2010
    Posts
    2

    Combining multiple COUNTIFS for monthly totals

    Hi, still wrestling with formulas. Here's my situation:

    I have multiple sheets in one workbook for each territory. The first column on all the sheets is "Date Received" with each range labelled accordingly. I want to total up all of the Client Registrations by month (in this case January) without having to create some huuuuge formula.

    =COUNTIFS(Abbotsford_date,">=1/1/2016",Abbotsford_date,"<=1/31/2016")+COUNTIFS(Agassiz_date,">=1/1/2016",Agassiz_date,"<=1/31/2016")

    I know there's probably a much slicker array that can be created but don't know how (or any other way that is easier than above).

    I would greatly appreciate any suggestions on how to fix this.

    Thanks.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Combining multiple COUNTIFS for monthly totals

    Hi Dave,

    There is a newer tool in Excel called Power Query. You can install it as an Add-In for 2010 and 2013 excel but it comes standard in 2016 Excel. This new tool is exactly what you want to combine all your sheets into a single sheet and then do a pivot on it and filter by date. Read about your problem at:

    http://www.excelguru.ca/blog/2014/11...g-power-query/
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    09-27-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    2010
    Posts
    2

    Re: Combining multiple COUNTIFS for monthly totals

    Thanks for the help, Marvin. I'll check that out

+ 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. Feeding multiple columns from one sheet into another while combining totals based 2 column
    By BabyBair0708 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-22-2015, 07:01 PM
  2. [SOLVED] How do I group daily totals into weekly/monthly/quarterly totals
    By situationroom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2013, 09:58 AM
  3. Replies: 3
    Last Post: 02-18-2013, 09:12 PM
  4. Running Monthly Totals on Multiple Sheets
    By Dragunov in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-29-2007, 12:57 AM
  5. [SOLVED] Summing Weekly Totals into Monthly Totals
    By steph44haf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-05-2006, 11:55 AM
  6. [SOLVED] Monthly Totals
    By Jasmine in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-27-2005, 05:05 PM
  7. How do I sum YTD totals based on monthly totals
    By Bsgrad02 in forum Excel General
    Replies: 3
    Last Post: 07-12-2005, 12: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