Formula Help - Summing a crosstable with multiple criteria (sumproduct?)

I can't seem to figure this one out. I tried different sumproduct variations but nothing seems to be working. I've attached an example of what I am trying to accomplish.

The data set area is what I am trying to sum from into the summary area. The criteria that I need to pull by customer is the month and the revenue or units field. Cell I4 should be 51,0000 and cell K4 should be 114,321.


I am not able to further manipulate the data set and am looking to put a formula in the highlighted section.


Any ideas?

Does this work for you?

Thanks for the reply.

It doesn't unfortunately because my working data set (not the example provided) is much larger and I am trying to make the formula pick up the correct values automatically through looking up the customer as you've done, but also to look up the month and what the reference value is (revenue, units, etc) without having to change the columns manually, especially as the month columns are dynamic and will change depending on date inputs.

Thanks a ton guys! Worked flawlessly!