+ Reply to Thread
Results 1 to 2 of 2

SUMIFS with months, names, values Multiple Criteria Based on Months and Names

  1. #1
    Registered User
    Join Date
    01-14-2016
    Location
    Concord, NC
    MS-Off Ver
    2013
    Posts
    16

    SUMIFS with months, names, values Multiple Criteria Based on Months and Names

    I'm trying to =sumifs( By different criteria but I'm having trouble.

    Column A are dates 1/3/2016, 1/5/2016, 2/6/2016 and so on for hundreds of lines
    Column B are names "jon" "bob" "bill"
    Column C are values $500, $600, $700

    I want to sum the values in "C" based on month of the year...THEN based on name.
    So Jon, in January, totals $500
    Bill in, February, totals $600

    I can get the values for each of these separately but when I try the SUMIFS it gives me an error.

    Any help is appreciated! Thank you!

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUMIFS with months, names, values Multiple Criteria Based on Months and Names

    Duplicate thread...

    https://www.excelforum.com/showthread.php?t=1166785
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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] 12 Months of Names to Master List
    By bodwhat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-07-2013, 03:23 PM
  2. Lookup and copy last months order BUT have similar names
    By king10001 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-23-2013, 05:39 AM
  3. Sumifs with multiple criteria for multiple names
    By mcayea in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 05-07-2013, 10:55 AM
  4. Replies: 2
    Last Post: 03-19-2013, 12:19 PM
  5. Replies: 5
    Last Post: 01-13-2012, 03:20 PM
  6. Trying to track names with days, months, and year(s)
    By casemanagerny in forum Excel General
    Replies: 8
    Last Post: 01-02-2012, 12:38 PM
  7. Changing Sheet Names Based on # Values in Names
    By Mordred in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-01-2010, 03:34 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