Hi guys, I'm trying to figure what formulas needs to be used to transfer funds between different financial accounts, based on criteria entered in cells.





I attach the Excel sample from Budget Tracker file itself. Any solution to this? (ps: no macros please, wont apply here)

https://www.msofficeforums.com/attac...1&d=1499716349

Not able to crack this one up for a while now...

Thanking in advance!

Attached Images

2017-07-10_1851.png (14.6 KB, 18 views)

Attached Files

transfer funds between accounts.xlsx (24.1 KB, 17 views)

which column are you wanting to transfer from transfers, D or E?

have you tried using a Vlookup SUM or a IFSUM formula might work for you.

Sorry i cannot provide the exact formula for you.