The reports in Salesforce already allow you to do this functionality. Are you looking to view that aggregate data in another place?
With Salesforce.com reports, you could have a report that shows you the total for each account in a summary, and drill down on each account if you'd wish.