Forum Discussion
DaveyMac
Feb 11, 2024Copper Contributor
Excel Running total reaching a threshold and choosing a corresponding date
Hi, I have a row of Dates in a Quarter (around 90 separate days) and below each date is a figure for the number of products sent that day. i want to cumulatively add (running total) the number of...
PeterBartholomew1
Feb 11, 2024Silver Contributor
This may or may not be what you require! It uses 365 and I do not 'do' backward compatibility.
= LET(
cumulative, SCAN(0, sent, SUM),
XLOOKUP(3, cumulative, VSTACK(date, cumulative), "not reached", 1)
)
PeterBartholomew1
Feb 11, 2024Silver Contributor
Despite having said I do not do backward compatibility, I had better remove the eta-reduced Lambda function for now!
= LET(
SUMĪ», LAMBDA(x,y, SUM(x,y)),
cumulative, SCAN(0, sent, SUMĪ»),
XLOOKUP(3, cumulative, VSTACK(date, cumulative), "not reached", 1)
)