Forum Discussion

Copper Contributor

Jun 13, 2018

Solved

complex finance formula

Im working on a finance spreadsheet. I want a formula that would allow me to 'transfer' money from one budget item to another budget item. For instance Cells Q12-42 (budget items) would look at C...

Formulas & Functions

Need Help

Matt Mickle
Jun 13, 2018
Hey John-

Hope you're doing well! Maybe try using a SUMIF() formula like the below example to solve your issue (See attached workbook for further reference):

TransferBetweenAccounts.xlsx11 KB

Matt Mickle

Bronze Contributor

Jun 13, 2018

Hey John-

Hope you're doing well! Maybe try using a SUMIF() formula like the below example to solve your issue (See attached workbook for further reference):

TransferBetweenAccounts.xlsx11 KB

john franklin
Copper Contributor
Jun 13, 2018
Wow, first response! thank you for you help! I had to tweak it just a tinge to get it to work the way I wanted, but its working fabulous.

Only thing I would ask differently, is if there is a way to make it work without having a "beginning balance" and an "ending balance". obviously you can hide the beginning balance, and thats what I've done for the moment. but other than that great help! Thank You!
- Matt Mickle
  Bronze Contributor
  Jun 13, 2018
  John-
  
  Glad you were able to resolve your issue. If those values are hardcoded the only way to do it is to create a helper column like you've done. If they are feeding from the monthly worksheets with a formula you can just combine the formulas.