VBA with PivotTable Count of Accounts - Want to show Sum of Accounts

Hello all,

I have a user form that has a button to run a PivotTable. All is working well except the Pivot is not showing the Sum of Accounts, instead it is showing the Count of Accounts.
(Was originally created in Office 2003, but have since upgraded to 2007, so not sure if this is a result.)

Could someone please direct me on how to correct the code below to show the Sum of Accounts for the PivotTable?

Please Login or Register  to view this content.

I assume I would add
"Sum of Accounts" in somewhere, just don't know where.

Thanks for any assistance,

Mike