Am not comfortable with Pivot table. Would like to use a formula

[Ciaz]

Hi,
I am trying to sum up the invoice amount based on the following:

1. Cost Center Name:
2. Cost center
3. GL Account.

Each cost center name has a cost center linked to it and each cost center has a number of GL Code linked to it. What I am trying to sum is the invoice amount for all GL Codes separately under a cost center & Cost center name.
My raw data is in Cells b10:j288 as of now.
The result which I expect is as given in rows 3,5,7 & 9.

Am using excel 2013.

Thanks,
Ciaz

[Herbds7]

Excel 2010
Excel 2013 compatible.
Some amounts formatted by you as text or with extra characters resulted in million dollar errors.
http://www.mediafire.com/view/1z0ut1hwsqc2r9l/08_10_15.xlsx