Subtotal Sum, and Subtotal Average on same row

Using Office 2007.

With the Subtotal command, I can receive the SUM for certain columns that I need.

I then use the Subtotal command again to get the AVERAGE percentage for another column. My Problem is, the Average creates another row above the Sum. I would like the average to just go on the same row as the Sum.

Attached is my spreadsheet, just need the code or tool that will allow me to drop the average into the blank box. (Performance Column) I will be using the Macro I have setup currently on many spreadsheets, so I need to code to work like it did with the sum where every change in campaign, it would sum the columns. I need average to do the same, where every change in campaign will put average in the performance column. Thanks for the help.

The "Dontwant" file is me finding the averages I need using the subtotal function, but creates an additional un-needed row.

The "want" file is the averages I need in the position I need, but I placed the averages there manually. Looking to automate the process. Thanks.

Does anyone need more info?