Spreadsheet: 838021d1690617305-sum-automate-formula-based-on-dynamically-change-value-sum-automate-formula-based-on-dyanamically-change-value
Sheet: Sheet1

 |  |  |  |  |  |  | Change Dynamically
SUM TOTAL |  |  | Correct Answer |  |  |  |  |  |  | 19660
TIME | PRODUCT NO | UNITS
2023-07-28 19:44:20.980000 | 19000 | 2722
2023-07-28 19:44:20.980000 | 19050 | 65
2023-07-28 19:44:20.980000 | 19100 | 821 |  |  | Dear Sir
2023-07-28 19:44:20.980000 | 19150 | 107 |  |  | I want automatic formula in column "C3".
2023-07-28 19:44:20.980000 | 19200 | 1646 |  |  | The data will continue to appear in column A, B and C below in time intervals of 1 minute
2023-07-28 19:44:20.980000 | 19250 | 259 |  |  | The unit number sum limit should be calculated on the basis of column "I4".
2023-07-28 19:44:20.980000 | 19300 | 2053 |  |  | Column "I4" has formula and it changes dynamically and is based on column "K4"
2023-07-28 19:44:20.980000 | 19350 | -845 |  |  | When the "K4" shape changes, the "I4" shape changes.
2023-07-28 19:44:20.980000 | 19400 | 8286 |  |  | Please check the correct answer in column "C4"
2023-07-28 19:44:20.980000 | 19450 | 2953
2023-07-28 19:44:20.980000 | 19500 | 25146
2023-07-28 19:44:20.980000 | 19550 | -10028
2023-07-28 19:44:20.980000 | 19600 | 98919
2023-07-28 19:44:20.980000 | 19650 | 65775
2023-07-28 19:44:20.980000 | 19700 | 159175
2023-07-28 19:44:20.980000 | 19750 | 113812
2023-07-28 19:44:20.980000 | 19800 | 197987
2023-07-28 19:44:20.980000 | 19850 | -68956
2023-07-28 19:44:20.980000 | 19900 | 106943
2023-07-28 19:44:20.980000 | 19950 | 44442
2023-07-28 19:44:20.980000 | 20000 | 110435
2023-07-28 19:44:20.980000 | 20050 | 53916
2023-07-28 19:44:20.980000 | 20100 | 65976
2023-07-28 19:44:20.980000 | 20150 | 31159
2023-07-28 19:44:20.980000 | 20200 | -137789
2023-07-28 19:44:20.980000 | 20250 | 54729
2023-07-28 19:44:20.980000 | 20300 | -107838
2023-07-28 19:44:20.980000 | 20350 | 31543
2023-07-28 19:44:20.980000 | 20400 | 85723
2023-07-28 19:44:20.980000 | 20450 | -33236
2023-07-28 19:44:20.980000 | 20500 | 167211
2023-07-28 19:44:25.550000 | 19000 | -2722
2023-07-28 19:44:25.550000 | 19050 | 65
2023-07-28 19:44:25.550000 | 19100 | 821
2023-07-28 19:44:25.550000 | 19150 | 107
2023-07-28 19:44:25.550000 | 19200 | 1646
2023-07-28 19:44:25.550000 | 19250 | 259
2023-07-28 19:44:25.550000 | 19300 | 2053
2023-07-28 19:44:25.550000 | 19350 | 845
2023-07-28 19:44:25.550000 | 19400 | 8286
2023-07-28 19:44:25.550000 | 19450 | 2953
2023-07-28 19:44:25.550000 | 19500 | 25146
2023-07-28 19:44:25.550000 | 19550 | 10028
2023-07-28 19:44:25.550000 | 19600 | 98919
2023-07-28 19:44:25.550000 | 19650 | 65775
2023-07-28 19:44:25.550000 | 19700 | 159175
2023-07-28 19:44:25.550000 | 19750 | 113812
2023-07-28 19:44:25.550000 | 19800 | 197987
2023-07-28 19:44:25.550000 | 19850 | 68956
2023-07-28 19:44:25.550000 | 19900 | 106943
2023-07-28 19:44:25.550000 | 19950 | 44442
2023-07-28 19:44:25.550000 | 20000 | 110435
2023-07-28 19:44:25.550000 | 20050 | 53916
2023-07-28 19:44:25.550000 | 20100 | 65976
2023-07-28 19:44:25.550000 | 20150 | 31159
2023-07-28 19:44:25.550000 | 20200 | 137789
2023-07-28 19:44:25.550000 | 20250 | 54729
2023-07-28 19:44:25.550000 | 20300 | 107838
2023-07-28 19:44:25.550000 | 20350 | 31543
2023-07-28 19:44:25.550000 | 20400 | 85723
2023-07-28 19:44:25.550000 | 20450 | 33236
2023-07-28 19:44:25.550000 | 20500 | 167211