Can I start a sumif at a particular row, then have it extend to every row following?

Jay Geoghegan

Here's an example of what I want but wont work, start at row 41 then capture every row following it. I've tried a helper column, didn't work. I need this because my automations seem to be arbitrarily skipping rows messing up my formulae, before you ask these rows were empty.

=SUM([Column1]41:[Column1])

Any Assistance is appreciated

Jason Tarpinian

No worries! For the RowID, use the system column:

For the Row# formula:

Then in my example, I use 10, instead of row 40.

Then you could take it to the next step with a column formula summing all values below the current row!

Jason Tarpinian

I love the Row# helper column for problems like this. To create it, build a System Column for the RowID, then build a Row# formula as follows

=MATCH(RowID@row, RowID:RowID, 0)

This will make sure your row # stays the actual row number as rows are inserted/deleted/moved. Then build out your formula with the Row# reference:

=SUMIFS([Column1]:[Column1], [Row#]:[Row#], >=41)

Jay Geoghegan

https://community.smartsheet.com/discussion/comment/473494#Comment_473494

I just can't wrap my head around it, If you could show examples using images I'd appreciate it, if not I understand

Jason Tarpinian

No worries! For the RowID, use the system column:

For the Row# formula:

Then in my example, I use 10, instead of row 40.

Then you could take it to the next step with a column formula summing all values below the current row!