# SUM IF function across multiple worksheets

1. ## 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.

Steve

2. ## 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. ## 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. ## Re: SUM IF function across multiple worksheets

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

5. ## 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.

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

#### 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