Spreadsheet: 787926d1658157410-count-the-number-of-unique-data-with-multiple-conditions-help-7-18
Sheet: Sheet1

 | fruit name | Amount | Date |  |  | Date | Amount 1-10 | Amount 11-20 | Amount 21-50 | Amount 51-100 | Amount100+
 | apple | 53 | 2022-07-01 00:00:00 |  | TABLE B | 2022-07-01 00:00:00 | 0 | 0 | 3 | 4 | 1 |  |  | 0 | 3 | 4 | 1
 | pear | 33 | 2022-07-01 00:00:00 |  |  | 2022-07-02 00:00:00 | 1 | 0 | 2 | 3 | 2 |  | 1 | 0 | 2 | 3 | 2
 | apple | 7 | 2022-07-01 00:00:00 |  |  | 2022-07-03 00:00:00 | 0 | 1 | 3 | 2 | 1 |  | 0 | 1 | 3 | 2 | 1
 | banana | 29 | 2022-07-01 00:00:00
 | durian | 27 | 2022-07-01 00:00:00 |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 4 | 1
 | Grape | 67 | 2022-07-01 00:00:00 |  |  | WITHOUT TABLE C  (Just for refer) |  |  |  |  |  | 2022-07-02 00:00:00 | 1 | 0 | 2 | 3 | 2
 | Grape | 85 | 2022-07-01 00:00:00 |  |  | fruit name | Amount | Date |  |  |  | 2022-07-03 00:00:00 | 0 | 1 | 3 | 2 | 1
 | peach | 61 | 2022-07-01 00:00:00 |  |  | apple | 60 | 2022-07-01 00:00:00
 | pear | 46 | 2022-07-01 00:00:00 |  |  | pear | 79 | 2022-07-01 00:00:00
 | longan | 89 | 2022-07-01 00:00:00 |  |  | banana | 29 | 2022-07-01 00:00:00
 | litchi | 23 | 2022-07-01 00:00:00 |  |  | durian | 27 | 2022-07-01 00:00:00
 | apple | 89 | 2022-07-02 00:00:00 |  |  | Grape | 152 | 2022-07-01 00:00:00
 | pear | 61 | 2022-07-02 00:00:00 |  |  | peach | 61 | 2022-07-01 00:00:00 |  | 38
 | apple | 27 | 2022-07-02 00:00:00 |  |  | longan | 89 | 2022-07-01 00:00:00 |  | 39
 | apple | 14 | 2022-07-02 00:00:00 |  |  | litchi | 23 | 2022-07-01 00:00:00 |  | 84
 | banana | 30 | 2022-07-02 00:00:00 |  |  | apple | 130 | 2022-07-02 00:00:00 |  | 129
 | durian | 43 | 2022-07-02 00:00:00 |  |  | pear | 74 | 2022-07-02 00:00:00 |  | 0
 | Grape | 41 | 2022-07-02 00:00:00 |  |  | banana | 30 | 2022-07-02 00:00:00 |  | 12
 | Grape | 6 | 2022-07-02 00:00:00 |  |  | durian | 47 | 2022-07-02 00:00:00 |  | 88
 | durian | 4 | 2022-07-02 00:00:00 |  |  | Grape | 129 | 2022-07-02 00:00:00
 | Grape | 7 | 2022-07-02 00:00:00 |  |  | peach | 85 | 2022-07-02 00:00:00
 | Grape | 75 | 2022-07-02 00:00:00 |  |  | longan | 51 | 2022-07-02 00:00:00 |  |  |  |  |  | 0 | 3 | 4 | 1
 | peach | 85 | 2022-07-02 00:00:00 |  |  | litchi | 7 | 2022-07-02 00:00:00 |  |  |  |  | 1 | 0 | 2 | 3 | 2
 | pear | 13 | 2022-07-02 00:00:00 |  |  | longan | 12 | 2022-07-03 00:00:00 |  |  |  |  | 0 | 1 | 3 | 2 | 1
 | longan | 51 | 2022-07-02 00:00:00 |  |  | litchi | 88 | 2022-07-03 00:00:00
 | litchi | 7 | 2022-07-02 00:00:00 |  |  | apple | 28 | 2022-07-03 00:00:00
 | longan | 12 | 2022-07-03 00:00:00 |  |  | pear | 38 | 2022-07-03 00:00:00
 | litchi | 88 | 2022-07-03 00:00:00 |  |  | banana | 39 | 2022-07-03 00:00:00 |  |  |  |  | 0 | 0 | 3 | 4 | 1
 | apple | 5 | 2022-07-03 00:00:00 |  |  | durian | 84 | 2022-07-03 00:00:00 |  |  |  | 2022-07-02 00:00:00 | 1 | 0 | 2 | 3 | 2
 | pear | 38 | 2022-07-03 00:00:00 |  |  | Grape | 129 | 2022-07-03 00:00:00 |  |  |  | 2022-07-03 00:00:00 | 0 | 1 | 3 | 2 | 1
 | apple | 7 | 2022-07-03 00:00:00
 | apple | 16 | 2022-07-03 00:00:00
 | banana | 39 | 2022-07-03 00:00:00
 | durian | 78 | 2022-07-03 00:00:00
 | Grape | 23 | 2022-07-03 00:00:00
 | Grape | 87 | 2022-07-03 00:00:00
 | durian | 6 | 2022-07-03 00:00:00
 | Grape | 19 | 2022-07-03 00:00:00
 |  | TABLE A