# Summing up a col without its first 5 rows

Options
✭✭
edited 11/07/22

Hey guys,

I'm trying to sum up all the rows above a certain row, but without the first four rows. for example:

At row 6 I want to sum only the values 0 and 14 from col "FE Days" to col "Sum Above". To row 7: 0,14 and 2.

I tried this formula: =SUMIF([Row ID(static)]:[Row ID(static)], <=[Row ID(static)]@row, [FE Days]:[FE Days]) - SUM([FE Days]1:[FE Days]4)

But it won't let me make it a col formula, I can only to it manually. It there an option to achieve it in a col formula way?

Thank you very much

• ✭✭✭✭✭✭
Options

Try this:

=SUMIFS([FE Days]:[FE Days], [Row ID(static)]:[Row ID(static)], AND(@cell > 4, @cell <= [Row ID(static)]@row))

• ✭✭✭✭✭✭
Options

What exactly is in [Row ID(static)]?

• ✭✭
Options

It's a col that keeps the row index- the first row will always stay 1 the second-2 even when I move the rows up/down

• ✭✭✭✭✭✭
Options

Try this:

=SUMIFS([FE Days]:[FE Days], [Row ID(static)]:[Row ID(static)], AND(@cell > 4, @cell <= [Row ID(static)]@row))

• ✭✭
Options

Thank you very much!!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!