Hi, I'm trying to sum a lot of data based on date (over 7,000 lines) and based on a number and having problems. Dates in column A, amounts in column B and type in column 3. The type can vary but starts with the same number. How can I sum these? Please note, 3 and 30 are not the same thing so can't be summed together however the others can be summed by 4 or 5 as they are the same. Thanks in advance.
<tbody>
</tbody>
07/01/2018 | 13.00 | 41 |
07/01/2018 | 14.00 | 40 |
07/01/2018 | 15.00 | 43 |
07/01/2018 | 16.00 | 50 |
07/01/2018 | 17.00 | 56 |
07/01/2018 | 18.00 | 30 |
07/01/2018 | 19.00 | 3 |
07/02/2018 | 20.00 | 3 |
07/02/2018 | 21.00 | 41 |
07/02/2018 | 22.00 | 5 |
07/02/2018 | 23.00 | 56 |
07/02/2018 | 24.00 | 42 |
07/02/2018 | 25.00 | 40 |
07/02/2018 | 26.00 | 30 |
<tbody>
</tbody>