Excel 2007 : Sumifs w/ Data in Horizontal Arrangement & Critieria Part of Sum Range

I've got a problem that I've been trying to solve for most of the day. Let me try to lay it out for you.

If have my data arranged horizontally for ease of entry and I would like to sum certain cells if certain conditions are met.

DATA ARRANGEMENT
Column B: Customer Name
Column C: PO#
Column D: PO Date
Column E: Type
Column F: Total Quantity
Column G: Ship Date
Column H: Quantity to Ship
Column I: Ship Date
Column J: Quantity to Ship
Column K: Ship Date
Column L: Quantity to Ship
Column M: Ship Date
Column N: Quantity to Ship
Column O: Ship Date
Column P: Quantity to Ship
Column Q: Ship Date
Column R: Quantity to Ship

Columns G through R reflect the fact that multiple shipments are often made on one purchase order.

I would like to sum the values in columns H, J, L, N, P, R based on whether the Customer Name and Type in the row match the same values on another worksheet and based on whether the date to the left of Quantity falls within a given month.

The data on my reporting spreadsheet is arranged as follows:

Column A: Customer Name
Column D: Quantity (where the sum would be reported)
Cell A2: Type

I would like to end up with the quantity to be shipped in a given month for a given customer and type.

The thing that seems to be giving me the biggest problem is that one of the criteria is referring to a value that to the left of the numbers that I want to sum and therefore part of the Sum Range.

Please help!!!

Thanks!