Support Board
Date/Time: Sun, 24 Nov 2024 15:52:58 +0000
Post From: Permanent/ Static Counter on Spreadsheet
| [2024-05-22 16:39:47] |
| alexo2022 - Posts: 47 |
|
I want to create counter on spreadsheet column that counts every time the other column contains the value "2" for example I use column P and Q. IF(Q3=2,COUNT(1),0). My goal is to count how many times column Q had the value "2". For example first time - Q3=2 -> Count 1 - P3=1 second time - Q3=2 -> Count 1 - P3=2 third time - Q3=2 -> Count 1 - P3=3 etc And I always want the see the last count on column P, in this example P3=3. the issue is that it works as long as the values are in the 1000 rows range, when they disappear all the counting is being reset. how can I resolve this issue ? Date Time Of Last Edit: 2024-05-22 16:41:15
|