SUMPRODUCT w/ multiple criteria

[delrancho153]

I am creating an excel worksheet to model future revenues and profits for a construction company. The company has 200 different projects across 4 divisions. I am attempting to subtotal by division using the following formula =SUMPRODUCT((MOD(ROW(P8:P283),2)=1)*($AS$8:$AS$283="RH")*(P8:P283))

The problem I am running into is the multiple joint venture projects the company is involved in. Each JV has a different share amount, eg 60/40, 70/30. I want to modify the divisional subtotal profit amounts to account for just our share of the profit excluding our partners share be it 30% or 40% or whatever. I have a column for each project noting the shares and the division.

Thanks for your help!

[tuph]

Please attach a sample of your workbook with sensitive data removed or replaced. This makes is much easier to test possible solutions using your own data.