I have been manually keeping a running total and want to apply a formula based on expense total. How

vknowles

VBAGuru

Not a great answer as you cannot make it a column formula, you could use "=[Expense Total]@row" for the first entry. Or just enter in that amount. Then for every cell after that use "=[Expense Total]@row+[Running Total]1".

The main problem is that you will have to have it copy down each time you add a new row. But if you select the last cell with the formula, you can drag the little square to fill in all rows below. It would save having to enter in a formula each time.

VBAGuru

Not a great answer as you cannot make it a column formula, you could use "=[Expense Total]@row" for the first entry. Or just enter in that amount. Then for every cell after that use "=[Expense Total]@row+[Running Total]1".

The main problem is that you will have to have it copy down each time you add a new row. But if you select the last cell with the formula, you can drag the little square to fill in all rows below. It would save having to enter in a formula each time.

vknowles

It worked!!! Thank you so much!

VBAGuru

Happy to help!