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 second-2 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
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!