Hi All:
I want to have a column of running totals next to a column of figures, so I need a formula like:
=sum($B1:B1)
=sum($B1:B2)
=sum($B1:B3)
– – – – – – – – –
=sum($B1:Bn)
Is there an easy way to get the fill-down feature to put these in my column. What I’ve been doing is make the first cell:
1. =sum(Y:B1) where Y is not being used. The cell says “#Name?”
2. Then I drag it down using the fill handle. The result is “#Name?” in all the cells.
3. Then with the cells selected, I replace all “Y” with “$B1”.
This works, but I’m wondering if there’s an easier way to put the formulas in all the cells.
Thanks,