Skip to content
  • Try for free

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

    ✭✭
    in Formulas and Functions

    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

    · Share on FacebookShare on Twitter

    Sign in
    Try for free

    Best Answer

    • Community Champion
      Answer ✓

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

      image.png

      For the Row# formula:

      image.png

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

      image.png

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

      image.png
      · Share on FacebookShare on Twitter

    Answers

    • Community Champion
      edited 02/19/25

      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)

      · Share on FacebookShare on Twitter
    • ✭✭
      Jason Tarpinian

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

      · Share on FacebookShare on Twitter
    • Community Champion
      Answer ✓

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

      image.png

      For the Row# formula:

      image.png

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

      image.png

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

      image.png
      · Share on FacebookShare on Twitter

    Sign in
    Try for free

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions