SOLVED

Formula for using a balance tally as a reference on another sheet

Copper Contributor

Hi, 

 

I have one bank account containing 2 separate funds used for fundraising purposes.
The 2 funds are represented on 2 Excel sheets. 

I want to use a formula that adds the two balances of the funds together as they change (to reflect the total balance of the account).    

I was playing with IF functions but could not figure it out.
Essentially, I'm trying to say:
On the sheet with the second fund, as you go down the balance column, if the cell has a value, take the lowest cell down the column, and add its value to the lowest cell down the column with the first fund's balance.

    
Thanks for any help... 

I'm using
PC/Windows 10/Office 2019   

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@GFennell Not sure I follow but perhaps like in the attached example.

 

Sheet1 calculated a running total of amounts and the last amount in column C is picked-up in Sheet2 as the "beginning balance" for the running total of the amounts in Sheet2.

 

If this makes no sense, please upload an example to clarify your intentions.

@Riny_van_Eekelen 

 

Thanks!  

I think that will work!

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@GFennell Not sure I follow but perhaps like in the attached example.

 

Sheet1 calculated a running total of amounts and the last amount in column C is picked-up in Sheet2 as the "beginning balance" for the running total of the amounts in Sheet2.

 

If this makes no sense, please upload an example to clarify your intentions.

View solution in original post