here is the data:
Mon 01 02 03 04 05 06 07 08 09 10 11 12
Actual 10 23 40 50 65
Fcst 8 20 44 55 60 70 55 55 50 40 30 20
The actuals are entered on a month end.
I need a formula to check the 'Actual' row for 0, and take the index and
create a dynamic array of Fcst Row and get a sum of the forecast.

In the above example, the actual is zero for 06, and need sum of Fcst row(
06:12), This will change for next month when actuals are entered for June.

Help is apprecited much
-- Jay