See attached if you're ever so inclined to follow allong...

20121011 Excel Help ex.xlsx

Sheet1:
Sales totals are populated: the "Sales Transaction", "Overhead", and the overall "Net" for each product. The sales totals are reported each month, with the month being grouped by quarter.

Sheet2:
I would like to perform a calculation to sum the "Net" for each product - by quarter. I really only care about the yellow "Object" (Object 1, 2, 3) products, so I devised a rather simplistic (and incorrect) SUMIFS statement just to show the general idea behind the calculation I am trying to execute in cell B5. Just to elaborate though, in cell B5, I'm attempting to display the total "Net" generated in '1st Qtr' (Jan-Mar) where the product is "Object*" (wildcard to include Object 1-3).

I'm certain this is a SUMPRODUCT job, but I didn't want to type out a bunch of garbage that would be incorrect anyway.

Any help would be certainly appreciated.


(Running Windows 7, Excel 2007 if it matters)