Spreadsheet: 849395d1699897249-how-to-count-only-unique-values-i-cannot-delete-duplicates-example-excel-f-rum
Sheet: Sheet1

 | How can I count non-black cells counting only unique values? In some cols I have duplicate values. The actual database has over 50k lines. I cannot remove duplicates because the last colum has a total
Lot | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | Total
1 | 3157 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 135760.5
 |  | 2607 |  |  |  |  |  |  |  |  |  |  |  |  |  | 79927.1
 |  | 2800 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18594
 |  | 2856 |  |  |  |  |  |  |  |  |  |  |  |  |  | 39060
 |  | 2801 |  |  |  |  |  |  |  |  |  |  |  |  |  | 32343.48
 |  | 2799 |  |  |  |  |  |  |  |  |  |  |  |  |  | 185922
 |  |  |  |  |  |  |  |  |  |  | 22418 |  |  |  |  | 56675.45
 | 2943 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 287487
 |  | 2606 |  |  |  |  |  |  |  |  |  |  |  |  |  | 37608
 |  |  |  |  |  |  |  | 22387 |  |  |  |  |  |  |  | 40167.61
 |  |  |  |  |  |  |  | 22387 |  |  |  |  |  |  |  | 95752.2
 |  |  |  |  |  |  | 13795 |  |  |  |  |  |  |  |  | 35868
 |  |  |  |  |  |  |  |  |  |  |  | 20060 |  |  |  | 28062.24
 |  |  |  |  |  |  |  |  |  |  |  | 19935 |  |  |  | 88271.88
 |  |  |  |  |  |  |  |  |  |  |  | 19952 |  |  |  | 70760
 |  |  |  |  |  |  |  |  |  |  |  | 19952 |  |  |  | 481.97
 |  |  | 5020 |  |  |  |  |  |  |  |  |  |  |  |  | 16425.34
 |  |  |  | 5994 |  |  |  |  |  |  |  |  |  |  |  | 1494.41
 |  |  |  | 5995 |  |  |  |  |  |  |  |  |  |  |  | 626.89
 |  |  |  |  | 8094 |  |  |  |  |  |  |  |  |  |  | 26832.67
 |  |  |  |  | 9191 |  |  |  |  |  |  |  |  |  |  | 89842.35
 |  |  |  |  | 9193 |  |  |  |  |  |  |  |  |  |  | 2248
 |  |  |  |  | 9421 |  |  |  |  |  |  |  |  |  |  | 8095.41
 |  |  |  |  | 9422 |  |  |  |  |  |  |  |  |  |  | 630
 |  |  |  |  |  | 11079 |  |  |  |  |  |  |  |  |  | 1098865.86
 |  |  |  |  |  | 11080 |  |  |  |  |  |  |  |  |  | 20304.25
 |  |  | 4874 |  |  |  |  |  |  |  |  |  |  |  |  | 20952.31
 |  |  |  | 5721 |  |  |  |  |  |  |  |  |  |  |  | 90087.66
 |  |  |  | 5722 |  |  |  |  |  |  |  |  |  |  |  | 21924.31
 |  |  |  | 5723 |  |  |  |  |  |  |  |  |  |  |  | 92820
 |  |  |  | 5724 |  |  |  |  |  |  |  |  |  |  |  | 1096.75
 |  |  |  |  | 9192 |  |  |  |  |  |  |  |  |  |  | 212849.89
 |  |  |  |  | 13333 |  |  |  |  |  |  |  |  |  |  | 309072
 |  | 3122 |  |  |  |  |  |  |  |  |  |  |  |  |  | 229680.6
 |  |  |  |  |  |  |  |  |  |  |  |  | 20319 |  |  | 106473.72
 |  |  |  |  |  |  |  |  |  | 17864 |  |  |  |  |  | 79200
 |  |  |  |  |  |  |  |  |  | 18267 |  |  |  |  |  | 24120
 |  |  |  |  |  |  |  |  | 17016 |  |  |  |  |  |  | 5922
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21200 | 66280
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21200 | 100920
 |  |  |  |  |  |  |  |  |  |  |  | 19770 |  |  |  | 87660
 |  |  |  |  |  |  |  |  |  | 22419 |  |  |  |  |  | 141138
 |  |  |  | 6930 |  |  |  |  |  |  |  |  |  |  |  | 130080
 |  |  |  |  | 10242 |  |  |  |  |  |  |  |  |  |  | 198960
 |  |  |  |  | 10300 |  |  |  |  |  |  |  |  |  |  | 642636
 |  |  |  |  |  |  | 22314 |  |  |  |  |  |  |  |  | 241116
 |  |  |  |  |  |  | 15033 |  |  |  |  |  |  |  |  | 301716
 |  |  |  |  |  |  | 22404 |  |  |  |  |  |  |  |  | 149916
 |  |  |  |  |  |  | 22404 |  |  |  |  |  |  |  |  | 35010
 |  |  |  |  |  |  | 22404 |  |  |  |  |  |  |  |  | 568363.64
 |  |  |  |  |  |  |  |  | 17521 |  |  |  |  |  |  | 8217.53
 |  |  |  |  |  |  |  |  | 22408 |  |  |  |  |  |  | 16262.4
 |  |  |  |  |  |  |  |  | 22408 |  |  |  |  |  |  | 2897
 |  |  |  |  |  |  |  |  | 22408 |  |  |  |  |  |  | 49980
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22304 |  | 11837.76
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22304 |  | 38840.52
 |  |  |  |  | 10129 |  |  |  |  |  |  |  |  |  |  | 89212.05
 |  |  |  |  | 10106 |  |  |  |  |  |  |  |  |  |  | 226980
 |  |  |  |  | 10127 |  |  |  |  |  |  |  |  |  |  | 56640
 |  |  |  |  | 10111 |  |  |  |  |  |  |  |  |  |  | 7560
 |  |  |  |  | 10126 |  |  |  |  |  |  |  |  |  |  | 498093.2
 |  |  |  |  |  |  |  |  |  | 18220 |  |  |  |  |  | 326433.47
 |  |  |  |  |  |  |  |  |  | 18220 |  |  |  |  |  | 625557
 |  |  |  |  |  |  |  |  |  |  |  | 19926 |  |  |  | 90860
 |  |  |  |  |  |  |  |  |  |  |  | 20122 |  |  |  | 117139.2
 |  |  |  |  | 8590 |  |  |  |  |  |  |  |  |  |  | 117139.2
 |  |  |  |  |  |  |  |  | 17044 |  |  |  |  |  |  | 0.01
 |  |  |  |  |  |  |  |  | 17044 |  |  |  |  |  |  | 169920
 |  |  |  |  |  |  |  |  | 17044 |  |  |  |  |  |  | 169920
 |  |  |  |  |  |  |  |  | 17044 |  |  |  |  |  |  | 77916
 |  |  |  |  |  |  |  |  | 17044 |  |  |  |  |  |  | 150960
 |  |  |  |  | 8801 |  |  |  |  |  |  |  |  |  |  | 211801
 |  |  |  |  | 9659 |  |  |  |  |  |  |  |  |  |  | 221052
 |  |  |  |  | 9669 |  |  |  |  |  |  |  |  |  |  | 136920
 |  |  |  |  | 9670 |  |  |  |  |  |  |  |  |  |  | 221052
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21182 | 2813.76