+ Reply to Thread
Results 1 to 5 of 5

SUM IF function across multiple worksheets

  1. #1
    Registered User
    Join Date
    02-22-2013
    Location
    Workington
    MS-Off Ver
    Excel 2010
    Posts
    33

    SUM IF function across multiple worksheets

    Hello,

    I would be very grateful of advice as to suitable equations for the attached sheet, relating to income/expenditure for a community organisation.

    Many thanks in advance

    Steve
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-10-2017
    Location
    INDIA
    MS-Off Ver
    365
    Posts
    129

    Re: SUM IF function across multiple worksheets

    Hi,

    Paste the below formula to respective cell where you need the sum,
    B3:
    Please Login or Register  to view this content.
    *Paste in B3 before copying to other location ie B13

    **Mark the thread as Solved if it gives you desirable

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,206

    Re: SUM IF function across multiple worksheets

    Use this formula in B2 of the Current sheet:

    =SUMIF('Payments in'!$F:$F,A2,'Payments in'!$C:$C)

    and copy down to B9. You can use a similar formula in B15:

    =SUMIF('Payments out'!$F:$F,A15,'Payments out'!$D:$D)

    and copy down to B19. You do not have an entry for YST, so the totals do not match with the Payments Out sheet.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    02-22-2013
    Location
    Workington
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: SUM IF function across multiple worksheets

    Thank you very much @Pete_UK and @Sunny18pc! Very much appreciated

  5. #5
    Forum Contributor
    Join Date
    11-10-2017
    Location
    INDIA
    MS-Off Ver
    365
    Posts
    129

    Re: SUM IF function across multiple worksheets

    Hi SJB777,

    You can mark the thread as Solved, and click * Add Reputation , another way of saying Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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