+ Reply to Thread
Results 1 to 2 of 2

SUMIFS name column matches, along with a specific date range

  1. #1
    Registered User
    Join Date
    08-22-2014
    Location
    Kelowna, Canada
    MS-Off Ver
    Office 2010
    Posts
    30

    SUMIFS name column matches, along with a specific date range

    Column A is a list of names (Jack, John, Sue), Column B is a date (dd/mm/yy format), Column C is a score.
    ON a separate sheet I want to have a chart that would add all scores by each individual based on a month selected. Cell A1 on sheet 2 would have the month and year listed (mm/yy format). Cell A2-A4 would have the list of the names (Jack, John, Sue). Cells B2-B4 would have a summed total of all scores listed on sheet 1 for each individual, but only would sum the scores that the mm/yy matched cell A1 on sheet 2.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,193

    Re: SUMIFS name column matches, along with a specific date range

    Try

    in B2 on Sheet2

    =SUMIFS(Sheet1!C:C,Sheet1!A:A,A2,Sheet1!B:B,">=" &DATE(YEAR($A$1),MONTH($A$1),1),Sheet1!B:B,"<=" &EOMONTH(DATE(YEAR($A$1),MONTH($A$1),1),0))


    Data on Sheet1

    Results on Sheet2
    Attached Files Attached Files
    Last edited by JohnTopley; 11-20-2016 at 05:16 AM.

+ 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] Macro for specific column for specific date range
    By romandotcom in forum Excel General
    Replies: 2
    Last Post: 02-03-2016, 08:51 AM
  2. Replies: 9
    Last Post: 10-08-2015, 01:50 PM
  3. Replies: 9
    Last Post: 06-28-2015, 08:07 PM
  4. Copy range to specific column with specific date with macro
    By SEERC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2015, 03:09 AM
  5. Replies: 3
    Last Post: 06-22-2013, 12:54 PM
  6. Replies: 1
    Last Post: 02-05-2013, 09:14 AM
  7. [SOLVED] Copy and Paste a specific Column to a Column that's heading matches a particular cell
    By Rexmond in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2012, 12:29 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