Forum Discussion

Copper Contributor

Dec 14, 2022

Solved

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.

smoiz

Copper Contributor

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.