SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2363974%22%20slang%3D%22en-US%22%3EFormula%20for%20using%20a%20balance%20tally%20as%20a%20reference%20on%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2363974%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20one%20bank%20account%20containing%202%20separate%20funds%20used%20for%20fundraising%20purposes.%3CBR%20%2F%3EThe%202%20funds%20are%20represented%20on%202%20Excel%20sheets.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20use%20a%20formula%20that%20adds%20the%20two%20balances%20of%20the%20funds%20together%20as%20they%20change%20(to%20reflect%20the%20total%20balance%20of%20the%20account).%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20playing%20with%20IF%20functions%20but%20could%20not%20figure%20it%20out.%3CBR%20%2F%3EEssentially%2C%20I'm%20trying%20to%20say%3A%3CBR%20%2F%3EOn%20the%20sheet%20with%20the%20second%20fund%2C%20as%20you%20go%20down%20the%20balance%20column%2C%20if%20the%20cell%20has%20a%20value%2C%20take%20the%20lowest%20cell%20down%20the%20column%2C%20and%20add%20its%20value%20to%20the%20lowest%20cell%20down%20the%20column%20with%20the%20first%20fund's%20balance.%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3EThanks%20for%20any%20help...%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20using%3CBR%20%2F%3EPC%2FWindows%2010%2FOffice%202019%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2363974%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2364091%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20for%20using%20a%20balance%20tally%20as%20a%20reference%20on%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2364091%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1056734%22%20target%3D%22_blank%22%3E%40GFennell%3C%2FA%3E%26nbsp%3BNot%20sure%20I%20follow%20but%20perhaps%20like%20in%20the%20attached%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESheet1%20calculated%20a%20running%20total%20of%20amounts%20and%20the%20last%20amount%20in%20column%20C%20is%20picked-up%20in%20Sheet2%20as%20the%20%22beginning%20balance%22%20for%20the%20running%20total%20of%20the%20amounts%20in%20Sheet2.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20makes%20no%20sense%2C%20please%20upload%20an%20example%20to%20clarify%20your%20intentions.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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!