AIS
New Member
Hello,
I was looking for a formula which will stop the SUM operation as soon as it finds the value in the column.
Here the summation will stop when in Fail column will finds 0 like the orange marked regardless of the values afterward. Here the Total sum will be 7 instead of 14 because of the 0.
I was looking for a formula which will stop the SUM operation as soon as it finds the value in the column.
Total | Pass | Fail |
36 | 35 | 1 |
58 | 57 | 1 |
32 | 34 | 1 |
59 | 58 | 1 |
42 | 41 | 1 |
77 | 75 | 2 |
44 | 44 | 0 |
53 | 52 | 1 |
57 | 55 | 2 |
52 | 50 | 2 |
54 | 53 | 1 |
49 | 48 | 1 |
Here the summation will stop when in Fail column will finds 0 like the orange marked regardless of the values afterward. Here the Total sum will be 7 instead of 14 because of the 0.