Sum until target, give a counter/ trigger once reached target, keep summing

Hey, I've got demand data for 6 months, I would like to sum the data until the capacity of truck say 1000kg is reached. Once the column reaches the 1000 mark I would like to get a trigger/ break tha...

excel

smoiz
Dec 15, 2022
smoiz
Used the following, worked for me since I had trigger column running parallel to data. The input reference is to the capacity value at which I want a trigger.

=IF(SUM(G$7)<QUOTIENT(SUM(F$7:F8),Inputs!C$4),IF(SUM(F$7:F8)>Inputs!C$4,1,0),0)

Thanks for all the help, appreciate it.

PeterBartholomew1

Silver Contributor

Dec 14, 2022

smoiz

This is a 365 solution that is probably total overkill for your requirement!

=LET(
    cumulative, SCAN(0,weight,LAMBDA(acc,w,IF(acc+w<=1000,acc+w,w))),
    newLoad,    IF(cumulative=weight,1,0),
    IF(VSTACK(DROP(newLoad,1),1), cumulative,"")
  )

Harun24HR

Bronze Contributor

Dec 14, 2022

Very tricky formula. Like it.

Forum Discussion

Sum until target, give a counter/ trigger once reached target, keep summing

Resources