PivotTable Sums

[Joey]

I have an Excel worksheet with three columns; Account number, Account Name
and Total. The Account Number and Account Name can have a one to many
relationship and so can the Total. For example:

Account NumberAccount Name Total