Sum multiple columns based on multiple variables

Guys,

I'm looking to find a formula to calculate the red cell (actually all the cells in the "type" fields) by determining:

1) If the Product in the table matches the one in row 3
2) If the dates in table columns H, J, L, N and P took place in the month before the billing date
3) If those two conditions are met, sum the matching columns in I, K, M, O and Q.

For example for the red cell would currently equal $11,380.02 as the only revenue collection dates in range would be cells I1 through I3.

Any help would be greatly appreciated. I'm sure there is a better way to set this up as well, but after three days of pretty serious number crunching and forecasting, my brain is mush.

Thanks
example.xlsx

I don't understand what you are referring to? I1 and I2 are blank, and I3 is a header row. Are you looking at I24, etc?

Ahhh, I see - typo on my part. Sorry it was a long day of data crunching and I had to type that out twice as I lost the post when I hit backspace once ...

That should have read I36 through I38. I got my wires crossed looking at the order number (1-3) instead of the row number.

Apologies.

Robert, trying your solution now.

Almost perfect and I've never tried table[product] before!

I just need it to calculate the previous month rather than current. I can fix that easily by adjusting columns for "Complete Date" and then +1 month in the next column for "Bill Date"

Thanks!