What to use Sumifs or SumProduct???

[vijanita]

Hi,
I am trying to collate data where there are multiple criteria to be compared and then the output is to be tabulated.
I have columns as under:

Locations: 4 in number
Cost center: 4 in number (one for each location)
GL Code: 14 in number (common to all cost centers)


In a month expenditure is done for each location under multiple GL code.
What I am trying to collate is the month wise expenditure for each Location for its cost center.
The link to a sample of my data is at:
https://drive.google.com/open?id=0B9...llUVHVtWmlscmc

I am using excel 2013.
Vijanita

[Pepe Le Mokko]

Please post on the forum. External links are unsafe and many members cannot access them, depriving you from valuable help

[vijanita]

Thanks, I have attached the file.

[vijanita]

Thanks Pepe. Have attached the file. Much obliged for the advice.
Vijanita