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)
)
- PeterBartholomew1Feb 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) )