Ciaz
New member
- Joined
- Aug 10, 2015
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
Hi,
I am trying to sum up the invoice amount based on the following:
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
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