+ Reply to Thread
Results 1 to 3 of 3

SUMIFS over two worksheets

  1. #1
    Registered User
    Join Date
    11-23-2022
    Location
    Sheffield, England
    MS-Off Ver
    Windows 10
    Posts
    7

    SUMIFS over two worksheets

    Hi,

    I'm trying to get a SUMIFS to work over two worksheets, (one returning the result of the formula from data held in the other), and I can't get it to work.
    The attached file shows the data and the workings - it's a cashbook, (where the data is held), with a cashflow report for a specific project on the other, (where the result needs to go).

    In cell K11 on sheet "CF report" - I want it to sum values from the sheet "Cashbook v2". It needs to:
    1) Look at the project reference in cell A2 on the "CF report" sheet and look it up in column G on the "Cashbook v2" sheet
    2) Look at the heading in col A, (in this case A11 - Income - Gifts / Donations), on the "CF report" sheet and look it up in column E on the "Cashbook v2" sheet
    3) Look at the date in row 4, (in this case cell K4 = Aug-2022), on the "CF report" and look it up in column K on the "Cashbook v2" sheet
    4) Return me the sum of values in column H on the "Cashbook v2" sheet in cell K11 on the "CF report" sheet

    The manual calculation in cell K11 on the "CF report" worksheet is what the value should be.

    Any help is greatly appreciated.

    Thank you,

    Lindsey
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,757

    Re: SUMIFS over two worksheets

    Your sample results formula is incorrect because two of the entries included are for September. The correct result is 14,270.61.

    Use this formula in K11. It can be copy/pasted to all rows in K.

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


    Note that the data in column K of Cashbook v2 is not dates, it is text. So a TEXT conversion is required the formula.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-23-2022
    Location
    Sheffield, England
    MS-Off Ver
    Windows 10
    Posts
    7

    Re: SUMIFS over two worksheets

    Thank you! That's sorted it for me.

+ 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] SUMIFS Across Multiple WorkSheets
    By keith6292 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-30-2019, 03:50 AM
  2. SUMIFS across Worksheets
    By her.rockstar in forum Excel General
    Replies: 4
    Last Post: 08-16-2018, 11:03 AM
  3. [SOLVED] Sumifs Across multiple worksheets
    By Jstns in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-21-2017, 11:58 AM
  4. [SOLVED] Sumifs on across multiple worksheets
    By alonsogtz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-08-2015, 06:19 PM
  5. SUMIFS across multiple worksheets
    By JNAllen1990 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-18-2015, 12:04 AM
  6. SUMIFS across several worksheets
    By codenamevincent in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-26-2014, 03:59 AM
  7. [SOLVED] SUMIFS with mutiple worksheets
    By figo12 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2013, 07:22 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