Sum Product for multiple criteria

Hello,

I am trying to find the total revenues by month and product from the attached spreadsheet. For example, cell c3 in Revenues 2010-2014 should return the total revenues from 2010 spreadsheet where Row A in 2010 matches cell C2 in Revenues 2010-2014 and column b in 2010 matches A3 IN Revenues 2010-2014. Now here is where I get confused. That will only return the total number of items sold, I need to multiply it by it's corresponding price in value J to get the total revenues. Here is my formula that does not work:
=SUMPRODUCT(('2010'!$K$1:$BJ$1='Revenues 2010-2014'!C$2)*('2010'!$B$3:$B$200='Revenues 2010-2014'!$A3),'2010'!K3:BJ200)*SUMPRODUCT(('2010'!K1:BJ1='Revenues 2010-2014'!C2)*('2010'!B3:B200='Revenues 2010-2014'!A3),'2010'!J3:J200)
Any suggestions?

Thanks,
Laura

That did not work, but thanks for your effort. I think I may need to input some sort of frequency function but I'm not quite sure how to do so.

Thanks,
Laura

Hello,

I had to shrink the file for size purposes, so not all of the types are in here. The correct value for cell C5 is 354,491. It is the sumproduct of all the unit sales in columns K-O in 2010 (which match cell C2 in Revenues 2010-2014) by their corresponding price in column J of 2010. Does this help? I have attached a new file highlighting the hardcoded cell with the correct value. I realize I could add total columns for each month on the 2010 sheet, but I would like something less time consuming.

thanks,
Laura

Glenn,

Thank you!!!!! I was stuck on this for hours!!!! Great work!

Laura