I have a spreadsheet that is receiving form responses and want to take the data from the responses and populate a spreadsheet with those responses.
The responses that I am getting are:
1. Date of Delivery
2. Location of Delivery
3. Amount of Delivery
Based on the results, I would like my spreadsheet to totalize all of the amount of delivery for a specific day based on which location of delivery.
For example:
| Date of Delivery | Location of Delivery | Amount of Propane Delivered (gallons) |
| 3/20/2020 | Mobile Equipment Bottle Filling | 584.5 |
| 3/20/2020 | Well Water Supply Building Heat | 67.8 |
| 3/18/2020 | Mobile Equipment Bottle Filling | 800.0 |
| 3/20/2020 | Mobile Equipment Bottle Filling | 300.0 |
I would like on the next sheet in the spreadsheet to in the cell under the column "Mobile Equipment Bottle Filling" to total all of the amounts that arrived on 3/20/2020 for just that location of delivery. In the next column, I would like to total all of the amounts that arrived on 3/20/2020 for "Well Water Supply Building Heat". I tried to use the VLOOKUP function, but that only gave me the 1st entry for a given day, and I couldn't get it based on both date and location. Please help. Thanks.
