Spreadsheet: 880332d1727966917-countifs-unique-value-with-multiple-criteria-countifs-unique-values-and-multiple-criteria
Sheet: Sheet1

 |  | Item 1 | Item 2 | Item 3 | Item 4 | Item 5
 |  | sample 1 | BC |  |  | 1000
 |  | sample 1 | BC |  |  | 2000
 |  | sample 3 | BC |  |  | 0
 |  | sample 4 | BC |  |  | 4000
 |  | sample 4 | BC |  |  | 5000
 |  | sample 4 | BC |  |  | 6000
 |  | sample 4 | BC |  |  | 7000
 |  | sample 4 | BC |  |  | 8000
 |  | sample 9 | BC |  |  | 9000
 |  | sample 10 | BC |  |  | 10000
 |  | sample 11 | BC & KD |  |  | 11000
 |  | sample 12 | BC |  |  | 12000
 |  | sample 12 | BC |  |  | 13000
 |  | sample 12 | BC |  |  | 14000
 |  | sample 15 | BC |  |  | 15000
 |  | sample 16 | BC |  |  | 0
 |  | sample 17 | BC |  |  | 0
 |  | sample 18 | BC |  |  | 0
 |  | sample 19 | BC |  |  | 19000
 |  | sample 20 | BC |  |  | 0
 |  | sample 21 | BC |  |  | 21000
 |  | sample 22 | BC |  |  | 22000
 |  | sample 23 | BC & KD |  |  | 23000
 |  | sample 23 | BC & KD |  |  | 24000
 |  | sample 23 | BC & KD |  |  | 25000
 |  | sample 23 | BC & KD |  |  | 26000
 |  | sample 23 | BC & KD |  |  | 27000
 |  | sample 28 | BD |  |  | 28000
 |  | sample 29 | BD |  |  | 29000
 |  | sample 30 | BD |  |  | 30000
 |  | sample 31 | BD |  |  | 31000
 |  | sample 32 | BD |  |  | 32000
 |  | sample 33 | BD |  |  | 33000
 |  | sample 34 | BC & KD |  |  | 34000
 |  | sample 34 | BC & KD |  |  | 35000
 |  | sample 34 | BC & KD |  |  | 36000
 |  | sample 34 | BC & KD |  |  | 37000
 |  | sample 34 | BC & KD |  |  | 38000
 |  | sample 34 | BC & KD |  |  | 39000
 |  | sample 34 | BC & KD |  |  | 40000
 |  | sample 41 | BC |  |  | 41000
 |  | sample 42 | BC |  |  | 42000
 |  | sample 43 | BC |  |  | 43000
 |  | sample 44 | BC |  |  | 44000
 |  | sample 45 | BC |  |  | 45000
 |  | sample 46 | BC |  |  | 46000
 |  | sample 47 | BC |  |  | 47000
 |  | sample 48 | BC |  |  | 48000
 |  | sample 49 | BC |  |  | 49000
 |  | sample 50 | BC |  |  | 50000
 |  | sample 51 | BC |  |  | 51000
 |  | sample 52 | BC |  |  | 52000
 |  | sample 52 | BC |  |  | 53000
 |  | sample 52 | BC |  |  | 54000
 |  | sample 52 | BC |  |  | 55000
 |  | sample 56 | BD |  |  | 56000
 |  | sample 57 | BD |  |  | 57000
 |  | sample 58 | BD |  |  | 0
 |  | sample 59 | BD |  |  | 0
 |  | sample 60 | BD |  |  | 60000
 |  | sample 61 | BC |  |  | 61000
 |  | sample 61 | BC |  |  | 62000
 |  | sample 61 | BC |  |  | 63000
 |  | sample 61 | BC |  |  | 64000
 |  | sample 61 | BC |  |  | 65000
 |  | sample 61 | BC |  |  | 66000
 |  | sample 61 | BC |  |  | 67000
 |  | sample 68 | BC |  |  | 68000
 |  | sample 69 | BC |  |  | 69000
 |  | sample 70 | BC |  |  | 70000
 |  | sample 71 | BC |  |  | 71000
 |  | sample 72 | BC |  |  | 72000
 |  | sample 73 | BC |  |  | 73000
 |  | sample 74 | BC |  |  | 74000
 |  | sample 75 | BC |  |  | 75000
 |  | sample 76 | BC |  |  | 76000
 |  | sample 77 | BC |  |  | 77000
 |  | sample 78 | BC |  |  | 78000
 |  | sample 79 | BC |  |  | 79000
 |  | sample 80 | BD |  |  | 80000
 |  | sample 80 | BD |  |  | 81000
 |  | sample 80 | BD |  |  | 82000
 |  | sample 80 | BD |  |  | 83000
 |  | sample 80 | BD |  |  | 84000
 |  | sample 85 | BD |  |  | 85000
 |  | sample 86 | BD |  |  | 86000
 |  | sample 87 | BD |  |  | 87000
 |  | sample 88 | BD |  |  | 88000
 |  | sample 89 | BD |  |  | 89000
 |  | sample 90 | BD |  |  | 90000
 |  | sample 91 | BC |  |  | 91000
 |  | sample 91 | BC |  |  | 92000
 |  | sample 91 | BC |  |  | 93000
 |  | sample 91 | BC |  |  | 94000
 |  | sample 95 | BC |  |  | 95000
 |  | sample 96 | BC |  |  | 96000
 |  | sample 97 | BC |  |  | 97000
 |  | sample 98 | BC |  |  | 98000
 |  | sample 99 | BC |  |  | 99000