calculation amounts for BANK & CASH across sheets based on matching partial item

Hi
the result should be in G2,G3 for BALANCES sheet.
in column (RECEIVED/PAID/NOT PAY) as in header for each sheet contains BANK or CASH should merge amounts are existed in last column with exclude AGGREGATE row from calculation across sheets first .
second should subtract the merged amounts from each other of them (RECEIVED -PAID) for BANK or CASH .
after that should sum the balance to B2,B3
example:
when merge RECEIVED for BANK for three sheets(SL,RS,VC)
RECEIVED BANK=40400+13400+480+120+200=54600
when merge PAID for BANK for four sheets(PR,RP,EP,VC)
PAID BANK=15000+2620+1100+1100+11500+1500+200+200=33200
after that should be 54600-33200=21380
final step when show the result in G2 for BANK should add to B2 will be like this=
21380+200000=221380 as show in G2
the same thing for CAH whether PAID or RECEIVED.
also posted in this forum
https://www.mrexcel.com/board/thread...-item.1257716/
if it's my way is really comlicated I accept any idea to make easy th solution.
any solution to do that will be great.

Your data in the file is inconsistent/wrong :

when merge RECEIVED for BANK for three sheets(SL,RS,VC)
RECEIVED BANK=40400+13400+480+120+200=54600

SL/SR do not have "RECEIVED BANK" only "PAID BANK" whereas VC has "RECEIVED BANK"....

when merge PAID for BANK for four sheets(SL,RS,EP,VC)
PAID BANK=15000+2620+1100+1100+11500+1500+200+200=33200

These figures do not agree with your file .....

"PAID BANK" in SL are 40,400 and 13,400

I don't see any diffrence in the file if it has been edited.

Sheet "SL" is NOT changed.

Please Login or Register  to view this content.

Why do some entries have PAYED and some PAID?

I'm guessing it is an error and all should be PAID...

Please Login or Register  to view this content.

Glad to have contributed...Tx for rep +

Thanks fo the rep