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

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

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

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

Hi SJB777,

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