multiple criteria summing problems

[plamb]

I posted something similar to this yesterday and got that handled (thanks, newdoverman!) but today have a new spreadsheet and now I can't get it to work.

On the JE tab, cell G6, I tried just a sumifs. Didn't work.
Cell F7, tried an array using the info from yesterday's solve. Didn't work......

Now I'm frustrated.

I'm trying to add all columns in the data tab that meet the criteria in the JE tab in columns A and L-O. So for example, cell f7 should add up all columns that have a "1" in row 1 of the data tab AND have a "600" in column A of the data tab. I calculated that this should be $17,073.48 but I'm getting $423,431.53 which Test Payroll file v2.xlsxis the total of ALL cost centers with code =1.

Help!
Peg

[NBVC]

Try in G6:

=SUMPRODUCT(data*(codes=A6))

and in F7:

=SUMPRODUCT((pr_cc=L7)*(codes=A7),data)

[plamb]

This works beautifully, NBVC. I have a question though. I didn't try to use SUMPRODUCT because I don't quite understand the logic. it seems to look for anything in the "data" that has the code equal to A6 then it multiplies those and finally adds them together. I don't get the multiplying bit. In my mind, I just want to add things up.......

Can you explain that to me?

Thanks,
Peg

[Ace_XL]

Nicely explained out here

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

[plamb]

Thanks a bunch!