SUMIFS to generate a running cumulative (based on date)

Getting an "Unparseable" error with this formula. Trying to add all values from "Unit Price" for dates in the Invoice Date column that are earlier or equal to the current row's Invoice Date.

Text of formula is here to play with:

=sumifs([Unit Price]:[Unit Price]@row,[Orig vs Invoice Add]:[Orig vs Invoice Add],"Cumulative",[Invoice Date]:[Invoice Date],<=[Invoice Date]@row)

Find more posts tagged with

Accepted answers

James Harris

Hi James. If you remove the "@row" from the first range, it should work.

i.e. =sumifs([Unit Price]:[Unit Price],[Orig vs Invoice Add]:[Orig vs Invoice Add],"Cumulative",[Invoice Date]:[Invoice Date],<=[Invoice Date]@row)

Thanks,

James

James Fischer

James, Thank you for your help! That was a rookie mistake...I was totally focused on a potential issue with how I was calling the "date" column...Did I need to use "Weeknumber", "Networkdays", etc.? Totally dumb mistake...and THANK YOU!

All comments

James Harris

Hi James. If you remove the "@row" from the first range, it should work.

i.e. =sumifs([Unit Price]:[Unit Price],[Orig vs Invoice Add]:[Orig vs Invoice Add],"Cumulative",[Invoice Date]:[Invoice Date],<=[Invoice Date]@row)

Thanks,

James

James Fischer

James Harris

No worries at all - it's very easily done! :)

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.