I have a sheet on a document that has all of the sponsorship donations that my team has received, and the name of the company that gave them to us. I want to take this information and sort the information and sum up the donations.
The information in the first spreadsheet is in a table with three columns, Name of the company, amount of the donation, date of donation.
For instance Spreadsheet one contains:
- Company1 | $5000 | 5/10/12
- Company2 | $6300 | 6/12/10
- Compnay1 | $750 | 8/9/11
- Company3 | $6800 | 6/17/10
- Compnay2 | $3000 | 8/29/12
I would like spreadsheet two to be:
- Compnay1 | $5700
- Compnay2 | $9300
- Compnay3 | $6800
How would I get this output?