+ Reply to Thread
Results 1 to 3 of 3

Sumif/Sumproduct based on Specific dates occurring in any given month

  1. #1
    Registered User
    Join Date
    11-23-2014
    Location
    Wichita
    MS-Off Ver
    2007
    Posts
    17

    Sumif/Sumproduct based on Specific dates occurring in any given month

    I am trying to accumulate the sum of a column (in my example, column B should be summed), for each name (column A), occurring in a month's time, with information provided by specific dates (column C), and calculated into the cells highlighted yellow.
    Furthermore, the specific dates will constantly change, as will the months/years I need sums for.
    So instead of using anything involving MONTH(C3:C22)=5, where it would specifically sum this month and this year, I would want it to sum all dates matching the month (and year) listed in row 2.
    End result in row 3 is filled in.

    Thanks in advance!
    PRACTICE SUMMING BY DATES.xlsx

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Sumif/Sumproduct based on Specific dates occurring in any given month

    Hi,

    Your profile doesn't mention your Excel version. Please change it. I'm going to assume you have Excel 2007 or later and hence you are able to use SUMIFS()

    In F3 copied to F3:S15

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,404

    Re: Sumif/Sumproduct based on Specific dates occurring in any given month

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Replies: 7
    Last Post: 01-14-2015, 11:38 PM
  2. SUMIF or SUMPRODUCT Within a month
    By dscheeringa in forum Excel General
    Replies: 4
    Last Post: 08-08-2012, 04:14 PM
  3. [Solved] SUMIF based on dates (month)
    By Russell719 in forum Excel General
    Replies: 4
    Last Post: 10-19-2010, 01:30 PM
  4. Replies: 8
    Last Post: 12-22-2009, 03:15 PM
  5. Replies: 7
    Last Post: 05-29-2009, 08:03 AM

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