Sum incremental cells

Jessintha Nathan

Hi,

I have 30 row in Col 2 and I want to return value in Col 3 at increment of each row.

Paul Newcome

Did you update the column name to reflect what is in your sheet?

And since you want the totals to stop at the row above, then you are going to want to put this in row 2 and dragfill down instead of the previous solution which also includes the current row.

=SUM([Column2]$1:[Column2]1)

Paul Newcome

Try something along the lines of...

=SUM([Col 2]$1:[Col 2]@row)

Jessintha Nathan

Annotation.png

it returned unparseable. I'm looking to sum cumulatively, for example FW 10 is total from FW 1 - 9.

Paul Newcome

Did you update the column name to reflect what is in your sheet?

And since you want the totals to stop at the row above, then you are going to want to put this in row 2 and dragfill down instead of the previous solution which also includes the current row.

=SUM([Column2]$1:[Column2]1)

Jessintha Nathan

Yes i did

Paul Newcome

Can you provide a screenshot of the formula in use similar to below?

Jessintha Nathan

The formula is not adding up previous column.

Paul Newcome

Can you provide a screenshot of what it is doing?

Jessintha Nathan

Paul Newcome

I need to see the exact formula you are using.

Jessintha Nathan

Jessintha Nathan

Paul Newcome

It looks like you are also going to need to update your row numbers.

Replace the number 1 with the first row you want to start with and put the formula in the row directly below it. Then you should be able to dragfill down the rest of the rows.

Jessintha Nathan

works perfectly, thank you Paul!

Paul Newcome

Great! Happy to help! 👍️