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?