SUMIFS to generate a running cumulative (based on date)

James Fischer

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)

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 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!

James Harris

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