Summarize a years earning forecast based on weights

[Karlbirger]

Hi

I have a formula that summarize a specific years forecasted earnings for each month, based on if the earning i committed (Yes) or not committed (No) and year.

=SUMPRODUCT(--(ECONOMIC!$H$6:$H$1000="Yes");--(YEAR(ECONOMIC!$I$6:$I$1000)=2011);ECONOMIC!J6:J1000)

This formula sums up the values for January (Column J) that corresponds to Committed "yes" (column H), year "2011" (column I).

I have a certain weight (percentage) in column AK which I want to weight for each value in each row in column J (in other words - I want to weight the forecasted earning for each month per row).

If column H=Yes and column I=2011, then multiply that row's value with the weight in that row in column AK then sum up all the values from all rows.


Thanks in advance
KB