Hi,
I am trying to sum up the invoice amount based on the following:
- Cost Center Name:
- Cost center
- 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
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
Bookmarks