How much have donors given the charity?

**keelbolt** · 01-21-2010, 09:51 AM

I have an excel 2007 spreadsheet with records showing individual donations from a large number of donors. The structure of the spreadsheet is essentially date, name, donation amount. Where a donor has given regularly, there are an equivalent number of records, one per donation.

I need a formula or VBA macro that will tell me how much each donor has given in total. I started by sorting the spreadsheet by donor surnames, which gave me a block of records for each donor, but it will take me years to go through each surname to total up their donations. Is there a quick formula for this, or a VBA prog I can use?

KB

**DonkeyOte** · 01-21-2010, 09:57 AM

Push your data into a Pivot Table (via Insert Tab on Ribbon)

Set Name as Row Label and Donation Amount as Data Value Field
(if you wish to further analyse by Month etc you can do but the above should suffice for time being based on your initial post)

**Palmetto** · 01-21-2010, 09:57 AM

Use a Pivot Table.

**keelbolt** · 01-22-2010, 04:41 AM

Thank you both! An excellent discovery and an excellent result. In PHP I would have used a variable, read each line and added the sum to the variable for the same donor until the donor name changed, and then printed the variable, cleared it, started again on the next donor name, etc. This is miles easier.