Karlbirger
Board Regular
- Joined
- Sep 21, 2011
- Messages
- 68
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.
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
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.
Code:
=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