Support Board
Date/Time: Sun, 24 Nov 2024 15:48:48 +0000
Post From: Permanent/ Static Counter on Spreadsheet
| [2024-05-23 13:40:44] |
| alexo2022 - Posts: 47 |
|
Try this:
=IF(Q3=2,P4+1,P4) It works as long as Q3=2, as soon as Q3=0 then it resets the counting. My goal is to have unique counts even when the data is no longer available in the spreadsheet. the color bar study, has counter that works like this. as a metaphor, I want to have a counter that tell me how many 3 points were in a quarter, in a basketball game, even though the quarter was already ended. |