Sum incremental cells
Hi,
I have 30 row in Col 2 and I want to return value in Col 3 at increment of each row.
Best Answer

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)
Answers

Try something along the lines of...
=SUM([Col 2]$1:[Col 2]@row)

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

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)

Yes i did

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

The formula is not adding up previous column.

Can you provide a screenshot of what it is doing?

I need to see the exact formula you are using.

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.

works perfectly, thank you Paul!

Great! Happy to help! 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 67 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!