Support Board
Date/Time: Sat, 01 Feb 2025 21:48:28 +0000
Post From: ,,,set counting to column,,,
| [2019-08-01 12:18:55] |
| Sawtooth - Posts: 4164 |
|
I've already tried .... /// not count correctly ////
It looks like the incrementing variable is not being reset with a TRUE in L3.=IF(L3, 0,IF(OR(K3, P4 > 0), P4 + 1, P4)) This formula counts correctly if there is a TRUE somewhere in L3. You'll need to reset the variable with another event. The first IF statement resets the incrementing variable to 0. The second IF statement begins the count. |