Sumproduct Array

[Bal_Ocado]

Hey Guys,

I have a set of data with data and projects, in the format below:

[Row 4, starting column F] Jan Feb Mar etc.

[Column B, starting row 6] Project A, Project B

I'm trying to sum all the forecast for for a project, based on the previous month's forecast - so i can compare with what's come in. The project in my summary tab is in column B, starting cell B12 and the date is in cell F2. I have the following formulae which i'm inputting with CTRL + shift - but it's giving me a value error

=SUMPRODUCT((Forecasts!$B$6:$B$200=$B12)*(Forecasts!K$4:AH$4=$F$2)*(Forecasts!K6:AH200))

any ideas on what this could be??

Thanks!

 

[steve the fish]

Probably a value error in the forecasts sheet within the range K6:AH200