Hello All,
I'm a fairly light excel user and am looking to do the following with the set of data below:
Beginning Balance BofA: $1,000
Beginning Balance WF: $1,500
<tbody>
</tbody>
I'm looking to have a running balance for 2 bank accounts (BofA and Paypal), as I record certain transactions. I was looking to have the column for "Type" to pull the corresponding amount and add or subtract it from the Beginning Balance - in that sense always having a running balance which is accurate based on recorded transactions.
How would I do this in an efficient way and which function would be best suited?
Thanks in advance!
I'm a fairly light excel user and am looking to do the following with the set of data below:
Beginning Balance BofA: $1,000
Beginning Balance WF: $1,500
Amount | Type |
-2 | BofA |
10 | Wells Fargo |
12 | BofA |
-5 | Wells Fargo |
<tbody>
</tbody>
I'm looking to have a running balance for 2 bank accounts (BofA and Paypal), as I record certain transactions. I was looking to have the column for "Type" to pull the corresponding amount and add or subtract it from the Beginning Balance - in that sense always having a running balance which is accurate based on recorded transactions.
How would I do this in an efficient way and which function would be best suited?
Thanks in advance!