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

Find more posts tagged with

Accepted answers

Paul Newcome

Try this:

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

All comments

Paul Newcome

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

Nitzan

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

Paul Newcome

Try this:

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

Nitzan

Thank you very much!!

Paul Newcome

Happy to help. 👍️

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.