+ Reply to Thread
Results 1 to 7 of 7

using Sumif/Sumproduct across multiple sheets

  1. #1
    Registered User
    Join Date
    01-10-2008
    Location
    Hong Kong
    Posts
    22

    using Sumif/Sumproduct across multiple sheets

    Hi there,
    I m having trouble with a simple formula where on my master sheet, i have 2 columns. One with the data and one with a value.

    I would like to a formula which will look at the dates/value on other sheets which will then tally up the number according to the date.

    Do i need to use an array of some sort? I have been messing about if the sumif statement but it doesn't work across multiple spreadsheets.

    Any tips or help would be most appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,604

    Re: using Sumif/Sumproduct across multiple sheets

    Is the list of dates always the same on all sheets?
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    01-10-2008
    Location
    Hong Kong
    Posts
    22

    Re: using Sumif/Sumproduct across multiple sheets

    yes sir, it is

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,604

    Re: using Sumif/Sumproduct across multiple sheets

    Then in D3 and down:
    Please Login or Register  to view this content.

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,604

    Re: using Sumif/Sumproduct across multiple sheets

    If different dates on each sheet, then something like:
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    01-10-2008
    Location
    Hong Kong
    Posts
    22

    Re: using Sumif/Sumproduct across multiple sheets

    Thanks Champ, that did the job. I was looking at the wrong formulas to use. this works well.

  7. #7
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: using Sumif/Sumproduct across multiple sheets

    Administrative Note:

    Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
    Thanks

+ 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. Combine sumif/sumproduct or sumproduct with multiple criteria
    By sab128 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-16-2018, 08:25 AM
  2. Replies: 2
    Last Post: 06-21-2017, 06:32 PM
  3. Sumproduct or multiple sumif's, I think?
    By chadboehne in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-03-2017, 06:20 AM
  4. Replies: 3
    Last Post: 09-01-2016, 05:08 AM
  5. Replies: 2
    Last Post: 01-23-2013, 06:25 AM
  6. Replies: 0
    Last Post: 08-17-2012, 02:02 PM
  7. Sumproduct/sumif/indirect across multiple workbooks, worksheets, multiple criteria
    By robgardner15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2011, 02:35 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