As you can see in the screenshot below, I have one column that is recording a daily count, while the second column is a sum of this count over an entire campaign.
How can I get the second column to auto-fill so that it sums from cell O3 down to the correct point – for instance cell P5 should be =sum(O3:O5)
, cell P6 should be =sum(O3:O6)
, etc.
Best Answer
Place the following formula in P3:
By locking the starting row of the range with
$
, We achieve the intended result.