Spreadsheet: 700250d1603095856-want-to-count-information-in-visable-rows-after-sorting-sample_v3
Sheet: Sheet1

Date | ID# | A | B | (Check Results)
2020-01-02 00:00:00 | 1 | 54.93373277057719 | 92.02226197073493
2020-01-02 00:00:00 | 19 | 33.1139939273851 | 79.38926810798753 | 1
2020-01-02 00:00:00 | 114 | 54.93373277057719 | 92.02226197073493 | 2
2020-01-03 00:00:00 | 1 | 91.73707046839166 | 84.7279771012649
2020-01-03 00:00:00 | 1 | 74.0536733691448 | 73.93934655638779
2020-01-03 00:00:00 | 22 | 69.71853925925922 | 19.7674303677732 | 1
2020-01-03 00:00:00 | 13 | 62.26212343952185 | 19.7674303677732 | 2
2020-01-03 00:00:00 | 9 | 74.68821686565968 | 10.61938992866364 | 3
2020-01-03 00:00:00 | 67 | 48.12849630647683 | 12.71923258434659 | 4
2020-01-03 00:00:00 | 81 | 80.30474947006205 | 96.77425598339097 | 5
2020-01-03 00:00:00 | 93 | 28.53380158033362 | 100 | 6
2020-01-03 00:00:00 | 105 | 48.99458607804889 | 23.99451095624278 | 7
2020-01-03 00:00:00 | 126 | 71.0191699499328 | 19.72269037821551 | 8
2020-01-03 00:00:00 | 144 | 36.12475012601662 | 24.19040952380948 | 9
2020-01-03 00:00:00 | 154 | 37.99110075444555 | 14.367820220638 | 10
2020-01-03 00:00:00 | 166 | 32.83582967515364 | 23.99451095624278
2020-01-03 00:00:00 | 195 | 14.46473632421279 | 14.367820220638
2020-01-03 00:00:00 | 243 | 65.42516671071061 | 36.34258522483628
2020-01-03 00:00:00 | 266 | 50.31335587426688 | 34.88373985937797
2020-01-03 00:00:00 | 327 | 70.00479039643845 | 36.34258522483628
2020-01-03 00:00:00 | 337 | 84.37269471945676 | 40.60452036793684
2020-01-03 00:00:00 | 366 | 44.81586529223414 | 37.59687984496127
2020-01-06 00:00:00 | 1 | 36.94818514283175 | 27.27274070247464
2020-01-06 00:00:00 | 1 | 61.68166139393874 | 41.79511711651109
2020-01-06 00:00:00 | 7 | 54.63427280498227 | 36.34258522483628 | 1
2020-01-06 00:00:00 | 1 | 43.32179238754325 | 34.88373985937797
2020-01-06 00:00:00 | 67 | 70.95862706273718 | 37.10188488883521 | 2
2020-01-06 00:00:00 | 1 | 46.20024050660548 | 36.34258522483628
2020-01-06 00:00:00 | 22 | 64.46985562054448 | 36.34258522483628 | 3
2020-01-06 00:00:00 | 19 | 45.25993537768078 | 34.88373985937797 | 4
2020-01-06 00:00:00 | 1 | 60.50488235634471 | 38.84700265173237
2020-01-06 00:00:00 | 1 | 47.39461065573768 | 42.78079070032325
2020-01-06 00:00:00 | 120 | 35.82320969447344 | 41.79511711651109 | 5
2020-01-06 00:00:00 | 126 | 35.2835341778997 | 37.59687984496127 | 6
2020-01-06 00:00:00 | 133 | 82.63612871952294 | 27.27274070247464 | 7
2020-01-06 00:00:00 | 161 | 31.63549343414246 | 34.88373985937797 | 8
2020-01-06 00:00:00 | 180 | 82.45902259091108 | 36.34258522483628 | 9
2020-01-06 00:00:00 | 201 | 50.42642821351214 | 37.59687984496127 | 10
2020-01-06 00:00:00 | 208 | 41.10822076657786 | 41.79511711651109
2020-01-06 00:00:00 | 243 | 32.45227368191824 | 40.60452036793684
2020-01-06 00:00:00 | 268 | 50.43816701256898 | 34.88373985937797
2020-01-06 00:00:00 | 328 | 30.81263992427992 | 28.75478449874398
2020-01-06 00:00:00 | 337 | 35.07038649928599 | 41.79511711651109
2020-01-06 00:00:00 | 349 | 84.88959430677248 | 41.79511711651109
2020-01-07 00:00:00 | 14 | 47.76728594820836 | 41.79511711651109 | 1
2020-01-07 00:00:00 | 1 | 28.51382158817584 | 36.34258522483628
2020-01-07 00:00:00 | 1 | 73.4894875675873 | 38.84700265173237
2020-01-07 00:00:00 | 1 | 22.62210796915167 | 36.34258522483628
2020-01-07 00:00:00 | 1 | 46.50287027417121 | 34.88373985937797
2020-01-07 00:00:00 | 1 | 42.02799392379632 | 27.27274070247464
2020-01-07 00:00:00 | 1 | 36.56802765976131 | 28.75478449874398
2020-01-07 00:00:00 | 1 | 69.03282939764394 | 36.34258522483628
2020-01-07 00:00:00 | 1 | 43.68951738825414 | 37.10188488883521
2020-01-07 00:00:00 | 1 | 40.19722704860296 | 34.88373985937797
2020-01-07 00:00:00 | 1 | 50.8089670192906 | 27.27274070247464
2020-01-07 00:00:00 | 1 | 65.65962786670258 | 27.27274070247464
2020-01-07 00:00:00 | 17 | 73.72701929840541 | 36.34258522483628 | 2
2020-01-07 00:00:00 | 1 | 50.01643279712235 | 34.88373985937797
2020-01-07 00:00:00 | 1 | 66.79632413473124 | 41.79511711651109
2020-01-07 00:00:00 | 1 | 57.87745854062042 | 42.78079070032325
2020-01-07 00:00:00 | 1 | 51.48772611290443 | 37.10188488883521
2020-01-07 00:00:00 | 1 | 36.44797819006001 | 37.59687984496127
2020-01-07 00:00:00 | 1 | 61.91547319383753 | 37.59687984496127
2020-01-07 00:00:00 | 1 | 60.24618429807051 | 40.60452036793684
 |  |  | Summary | Results |  | The correct answer Im looking for if I filter to remove "1" in the ID column
 |  |  | 2020-01-02 00:00:00 |  |  | 2
 |  |  | 2020-01-03 00:00:00 |  |  | 14
 |  |  | 2020-01-06 00:00:00 |  |  | 12
 |  |  | 2020-01-07 00:00:00 |  |  | 1
 |  |  | Date | ID# | A | B | (Check Results)
 |  |  | 2020-01-02 00:00:00 | 19 | 33.1139939273851 | 79.38926810798753 | 1
 |  |  | 2020-01-02 00:00:00 | 114 | 54.93373277057719 | 92.02226197073493 | 2
 |  |  | 2020-01-03 00:00:00 | 22 | 69.71853925925922 | 19.7674303677732 | 1
 |  |  | 2020-01-03 00:00:00 | 13 | 62.26212343952185 | 19.7674303677732 | 2
 |  |  | 2020-01-03 00:00:00 | 9 | 74.68821686565968 | 10.61938992866364 | 3
 |  |  | 2020-01-03 00:00:00 | 67 | 48.12849630647683 | 12.71923258434659 | 4
 |  |  | 2020-01-03 00:00:00 | 81 | 80.30474947006205 | 96.77425598339097 | 5
 |  |  | 2020-01-03 00:00:00 | 93 | 28.53380158033362 | 100 | 6
 |  |  | 2020-01-03 00:00:00 | 105 | 48.99458607804889 | 23.99451095624278 | 7
 |  |  | 2020-01-03 00:00:00 | 126 | 71.0191699499328 | 19.72269037821551 | 8
 |  |  | 2020-01-03 00:00:00 | 144 | 36.12475012601662 | 24.19040952380948 | 9
 |  |  | 2020-01-03 00:00:00 | 154 | 37.99110075444555 | 14.367820220638 | 10
 |  |  | 2020-01-06 00:00:00 | 7 | 54.63427280498227 | 36.34258522483628 | 1
 |  |  | 2020-01-06 00:00:00 | 67 | 70.95862706273718 | 37.10188488883521 | 2
 |  |  | 2020-01-06 00:00:00 | 22 | 64.46985562054448 | 36.34258522483628 | 3
 |  |  | 2020-01-06 00:00:00 | 19 | 45.25993537768078 | 34.88373985937797 | 4
 |  |  | 2020-01-06 00:00:00 | 120 | 35.82320969447344 | 41.79511711651109 | 5
 |  |  | 2020-01-06 00:00:00 | 126 | 35.2835341778997 | 37.59687984496127 | 6
 |  |  | 2020-01-06 00:00:00 | 133 | 82.63612871952294 | 27.27274070247464 | 7
 |  |  | 2020-01-06 00:00:00 | 161 | 31.63549343414246 | 34.88373985937797 | 8
 |  |  | 2020-01-06 00:00:00 | 180 | 82.45902259091108 | 36.34258522483628 | 9
 |  |  | 2020-01-06 00:00:00 | 201 | 50.42642821351214 | 37.59687984496127 | 10
 |  |  | 2020-01-07 00:00:00 | 14 | 47.76728594820836 | 41.79511711651109 | 1
 |  |  | 2020-01-07 00:00:00 | 17 | 73.72701929840541 | 36.34258522483628 | 2