Spreadsheet: 804121d1667905258-countifs-with-duplicates-excel-challenge
Sheet: Actual Sales

 | ID | Date | Week | Month | Year | Customer | Clam type | Volume in kg | Price/kg | Total Sales
 | OF-000001 | 2023-01-05 00:00:00 |  |  |  | Customer A | [NAME] | 314 | 10
 | OF-000002 | 2023-01-08 00:00:00 |  |  |  | Customer B | Venerupis Corrugata | 118 | 10
 | OF-000003 | 2023-01-11 00:00:00 |  |  |  | Customer A | [NAME] | 369 | 14.11
 | OF-000004 | 2023-01-14 00:00:00 |  |  |  | Customer B | Venerupis Corrugata | 56 | 10
 | OF-000005 | 2023-01-17 00:00:00 |  |  |  | Customer C | Venerupis Corrugata | 463 | 15.91
 | OF-000006 | 2023-01-20 00:00:00 |  |  |  | Customer D | [NAME] | 138 | 10
 | OF-000007 | 2023-01-23 00:00:00 |  |  |  | Customer E | [NAME] | 480 | 10
 | OF-000008 | 2023-01-26 00:00:00 |  |  |  | Customer F | Venerupis Corrugata | 301 | 10.52
 | OF-000009 | 2023-01-29 00:00:00 |  |  |  | Customer D | Venerupis Corrugata | 90 | 10
 | OF-000010 | 2023-02-01 00:00:00 |  |  |  | Customer F | [NAME] | 199 | 14.28
 | OF-000011 | 2023-02-04 00:00:00 |  |  |  | Customer A | Venerupis Corrugata | 14 | 17.83
 | OF-000012 | 2023-02-04 00:00:00 |  |  |  | Customer A | Venerupis Corrugata | 300 | 17.83
 | OF-000013 | 2023-02-04 00:00:00 |  |  |  | Customer A | Venerupis Corrugata | 423 | 17.83
 | OF-000014 | 2023-02-04 00:00:00 |  |  |  | Customer A | Venerupis Corrugata | 533 | 17.83
 | OF-000015 | 2023-02-04 00:00:00 |  |  |  | Customer A | Venerupis Corrugata | 294 | 17.83
 | OF-000016 | 2023-02-07 00:00:00 |  |  |  | Customer B | [NAME] | 238 | 12.27
 | OF-000017 | 2023-02-10 00:00:00 |  |  |  | Customer G | [NAME] | 335 | 10
 | OF-000018 | 2023-02-13 00:00:00 |  |  |  | Customer H | [NAME] | 304 | 10
 | OF-000019 | 2023-02-16 00:00:00 |  |  |  | Customer A | Venerupis Corrugata | 497 | 23.26
 | OF-000020 | 2023-02-19 00:00:00 |  |  |  | Customer E | [NAME] | 392 | 23.64
 | OF-000021 | 2023-02-22 00:00:00 |  |  |  | Customer F | Venerupis Corrugata | 370 | 10
 | [NAME] | 2023-02-25 00:00:00 |  |  |  | Customer D | [NAME] | 267 | 10
 | OF-000023 | 2023-02-28 00:00:00 |  |  |  | Customer F | [NAME] | 322 | 15.02
 | OF-000024 | 2023-03-03 00:00:00 |  |  |  | Customer A | Venerupis Corrugata | 459 | 10.19
 | OF-000025 | 2023-03-06 00:00:00 |  |  |  | Customer B | Venerupis Corrugata | 460 | 10
 | OF-000026 | 2023-03-09 00:00:00 |  |  |  | Customer D | Venerupis Corrugata | 469 | 10
 | OF-000027 | 2023-03-12 00:00:00 |  |  |  | Customer E | Venerupis Corrugata | 363 | 10
 | OF-000028 | 2023-03-15 00:00:00 |  |  |  | Customer D | [NAME] | 423 | 17.78
 | OF-000029 | 2023-03-18 00:00:00 |  |  |  | Customer F | [NAME] | 177 | 10
 | OF-000030 | 2023-03-21 00:00:00 |  |  |  | Customer A | [NAME] | 65 | 24.29
 | OF-000031 | 2023-03-03 00:00:00 |  |  |  | Customer A | Venerupis Corrugata | 459 | 10.19
 | OF-000032 | 2023-03-06 00:00:00 |  |  |  | Customer B | Venerupis Corrugata | 460 | 10
 | OF-000033 | 2023-03-09 00:00:00 |  |  |  | Customer D | Venerupis Corrugata | 469 | 10
 | OF-000034 | 2023-03-12 00:00:00 |  |  |  | Customer E | Venerupis Corrugata | 363 | 10
 | OF-000035 | 2023-03-15 00:00:00 |  |  |  | Customer D | [NAME] | 423 | 17.78
 | OF-000036 | 2023-03-18 00:00:00 |  |  |  | Customer F | [NAME] | 177 | 10
 | OF-000037 | 2023-03-21 00:00:00 |  |  |  | Customer A | [NAME] | 65 | 24.29
 | OF-000038 | 2023-03-18 00:00:00 |  |  |  | Customer F | [NAME] | 177 | 10
 | OF-000039 | 2023-03-21 00:00:00 |  |  |  | Customer A | [NAME] | 65 | 24.29
 | OF-000040 | 2023-03-24 00:00:00 |  |  |  | Customer B | Venerupis Corrugata | 326 | 10
 | OF-000041 | 2023-03-27 00:00:00 |  |  |  | Customer D | Venerupis Corrugata | 165 | 10
 | OF-000042 | 2023-03-30 00:00:00 |  |  |  | Customer D | Venerupis Corrugata | 201 | 15.68
 | OF-000043 | 2023-04-02 00:00:00 |  |  |  | Customer F | [NAME] | 179 | 17.56
 | [NAME] | 2023-04-05 00:00:00 |  |  |  | Customer G | Venerupis Corrugata | 97 | 13.71
 | OF-000045 | 2023-04-08 00:00:00 |  |  |  | Customer H | [NAME] | 385 | 10
 | OF-000046 | 2023-04-11 00:00:00 |  |  |  | Customer A | [NAME] | 379 | 10
 | OF-000047 | 2023-04-14 00:00:00 |  |  |  | Customer E | Venerupis Corrugata | 373 | 10
 | OF-000048 | 2023-04-17 00:00:00 |  |  |  | Customer F | [NAME] | 185 | 24.37
 | OF-000049 | 2023-04-20 00:00:00 |  |  |  | Customer D | [NAME] | 154 | 10
 | OF-000050 | 2023-04-05 00:00:00 |  |  |  | Customer G | Venerupis Corrugata | 97 | 13.71
 | OF-000051 | 2023-04-08 00:00:00 |  |  |  | Customer H | [NAME] | 385 | 10
 | OF-000052 | 2023-04-11 00:00:00 |  |  |  | Customer A | [NAME] | 379 | 10
 | OF-000053 | 2023-04-14 00:00:00 |  |  |  | Customer E | Venerupis Corrugata | 373 | 10
 | OF-000054 | 2023-04-17 00:00:00 |  |  |  | Customer F | [NAME] | 185 | 24.37
 | OF-000055 | 2023-04-20 00:00:00 |  |  |  | Customer D | [NAME] | 154 | 10
 | [NAME] | 2023-04-17 00:00:00 |  |  |  | Customer F | [NAME] | 185 | 24.37
 | OF-000057 | 2023-04-20 00:00:00 |  |  |  | Customer D | [NAME] | 154 | 10
 | OF-000058 | 2023-04-23 00:00:00 |  |  |  | Customer F | Venerupis Corrugata | 458 | 12.1
 | OF-000059 | 2023-04-26 00:00:00 |  |  |  | Customer G | [NAME] | 293 | 17.42
 | OF-000060 | 2023-04-29 00:00:00 |  |  |  | Customer H | [NAME] | 470 | 24.01
 | OF-000061 | 2023-05-02 00:00:00 |  |  |  | Customer A | Venerupis Corrugata | 70 | 23.83
 | OF-000062 | 2023-05-05 00:00:00 |  |  |  | Customer E | [NAME] | 360 | 18.25
 | OF-000063 | 2023-05-08 00:00:00 |  |  |  | Customer F | Venerupis Corrugata | 471 | 10
 | OF-000064 | 2023-05-11 00:00:00 |  |  |  | Customer D | Venerupis Corrugata | 561 | 10
 | [NAME] | 2023-05-02 00:00:00 |  |  |  | Customer A | Venerupis Corrugata | 70 | 23.83
 | OF-000066 | 2023-05-05 00:00:00 |  |  |  | Customer E | [NAME] | 360 | 18.25
 | OF-000067 | 2023-05-08 00:00:00 |  |  |  | Customer F | Venerupis Corrugata | 471 | 10
 | OF-000068 | 2023-05-02 00:00:00 |  |  |  | Customer A | Venerupis Corrugata | 355 | 23.83
 | OF-000069 | 2023-05-05 00:00:00 |  |  |  | Customer E | [NAME] | 360 | 18.25
 | OF-000070 | 2023-05-02 00:00:00 |  |  |  | Customer A | Venerupis Corrugata | 270 | 23.83
 | OF-000071 | 2023-05-05 00:00:00 |  |  |  | Customer E | [NAME] | 360 | 18.25
 | OF-000072 | 2023-05-08 00:00:00 |  |  |  | Customer F | Venerupis Corrugata | 471 | 10
 | OF-000073 | 2023-05-14 00:00:00 |  |  |  | Customer F | [NAME] | 152 | 16.43
 | OF-000074 | 2023-05-17 00:00:00 |  |  |  | Customer A | [NAME] | 310 | 17.8
 | OF-000075 | 2023-05-05 00:00:00 |  |  |  | Customer E | [NAME] | 360 | 18.25
 | OF-000076 | 2023-05-08 00:00:00 |  |  |  | Customer F | Venerupis Corrugata | 471 | 10
 | OF-000077 | 2023-05-14 00:00:00 |  |  |  | Customer F | [NAME] | 152 | 16.43
 | OF-000078 | 2023-05-17 00:00:00 |  |  |  | Customer A | [NAME] | 340 | 17.8
 | [NAME] | 2023-05-20 00:00:00 |  |  |  | Customer G | [NAME] | 475 | 10
 | OF-000080 | 2023-05-23 00:00:00 |  |  |  | Customer H | Venerupis Corrugata | 171 | 17.67
 | OF-000081 | 2023-05-26 00:00:00 |  |  |  | Customer A | [NAME] | 489 | 23.67
 | OF-000082 | 2023-05-29 00:00:00 |  |  |  | Customer E | Venerupis Corrugata | 246 | 21.4
 | OF-000083 | 2023-06-01 00:00:00 |  |  |  | Customer F | Venerupis Corrugata | 144 | 14.68
 | OF-000084 | 2023-06-04 00:00:00 |  |  |  | Customer D | [NAME] | 446 | 10
 | OF-000085 | 2023-06-07 00:00:00 |  |  |  | Customer F | [NAME] | 61 | 12.56
 | OF-000086
 | OF-000087
 | OF-000088
 | OF-000089
 | [NAME]
 | OF-000091
 | [NAME]
 | OF-000093
 | OF-000094
 | OF-000095
 | OF-000096
 | OF-000097
 | OF-000098
 | OF-000099
 | OF-000100
 | OF-000101
 | OF-000102
 | OF-000103
 | OF-000104
 | OF-000105
 | OF-000106
 | OF-000107
 | OF-000108
 | OF-000109
 | [NAME]
 | OF-000111
 | OF-000112
 | OF-000113
 | OF-000114
 | OF-000115
 | OF-000116
 | OF-000117
 | OF-000118
 | OF-000119
 | OF-000120
 | OF-000121
 | OF-000122
 | OF-000123
 | OF-000124
 | OF-000125
 | OF-000126
 | OF-000127
 | OF-000128
 | OF-000129
 | OF-000130
 | OF-000131
 | OF-000132
 | OF-000133