Support Board
Date/Time: Fri, 16 May 2025 21:20:11 +0000
Post From: Permanent/ Static Counter on Spreadsheet
| [2024-05-23 13:50:38] |
| Sawtooth - Posts: 4216 |
|
as soon as Q3=0 then it resets the counting.
That's not what I'm seeing.Try this: Put this in e.g. S3: =IF(S4=10,0,S4+1) This will count from 0 to 10, and repeat. P3: =IF(S3=2,P4+1,P4) This will increment the count by 1 each time there is a 2 in column S, and make it persistent until the next 2. |