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)
Help Article Resources
Check out the Formula Handbook template!