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

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:


  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
 

Attachments

  • Sumifs or Sum Product.xlsx
    34.9 KB · Views: 19
Back
Top