Summing up a col without its first 5 rows
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
Best Answer

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

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

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

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

Thank you very much!!

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!