Automatically sum categories in a pivot table?

Occasional Visitor

I have a simple table of about 1,200 transactions (rows) of three columns (Vendor, amount, date). Most of the transactions are from the same 125 or so vendors. Some vendors have 25-30 transactions, most 5-10. The other transactions are one-offs. Is there a simple way in Excel to automatically calculate a total for each of the 125 repeating vendors so I don’t have to calculate each one myself to get a summary of the 1,200 transactions?

1 Reply


I'd create a pivot table based on the data. Add the Vendor field (column) to the Rows area and the Amount field to the Values area.

See Create a Pivot Table in Excel