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

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

Find more posts tagged with

Accepted answers

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!

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.