Support Board
Date/Time: Sun, 24 Nov 2024 15:46:00 +0000
Post From: Permanent/ Static Counter on Spreadsheet
| [2024-05-23 13:50:38] |
| Sawtooth - Posts: 4119 |
|
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. |