+ Reply to Thread
Results 1 to 4 of 4

Multiple Sumifs

  1. #1
    Registered User
    Join Date
    10-31-2014
    Location
    Norwich
    MS-Off Ver
    Office 2013
    Posts
    6

    Multiple Sumifs

    Hi there

    I'm having trouble using multiple sumifs. I have sales data in one tab showing customers orders. The data includes customer name, sales value and shipment month. There may be multiple sales for each customer in the same or separate months. In tab 2 I have a summary table showing customers down one side and months along the top. I want to summarise what each customer sold in each month. I've attached a file to this thread (I think) as an example of the information.
    Any help would be greatly appreciated!

    Many Thanks

    Jack
    Attached Files Attached Files

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Multiple Sumifs

    Hi,

    In C2 enter this formula
    =SUMIFS(Information!$C:$C,Information!$A:$A,$A2,Information!$B:$B,$B2,Information!$D:$D,C$1)
    and then fill across and down as needed.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    10-31-2014
    Location
    Norwich
    MS-Off Ver
    Office 2013
    Posts
    6

    Re: Multiple Sumifs

    Thank you so, so much. I really appreciate your quick response on this!

    Jack

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Multiple Sumifs

    You're welcome.

+ 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: 0
    Last Post: 08-22-2017, 03:49 PM
  2. [SOLVED] SUMIFS across multiple sheets using multiple criteria function not working
    By ghostly1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-03-2017, 04:41 PM
  3. Replies: 5
    Last Post: 02-06-2015, 08:44 PM
  4. [SOLVED] Sumifs with multiple lookups with multiple results to lookup other values
    By malisesaucier in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-10-2013, 01:13 AM
  5. Using a SUMIFS across multiple sheets with multiple criteria
    By Auto667 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-06-2013, 06:55 AM
  6. Replies: 2
    Last Post: 01-23-2013, 06:25 AM
  7. SUMIFS Puzzle - Trying to avoid adding multiple SUMIFS to get valid result
    By haldavid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2013, 03:42 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