#NA Error with Sumproduct

[taylo40]

Hello,

Appreciate some help with the sumproduct function.

I have created a sumproduct formula and it works fine

=SUMPRODUCT(((CM_Year=YEAR(CM_CurrentMonth))*('Data Sheet'!$B$5:$B$388<=CM_CurrentMonth)*('Data Sheet'!$F$5:$F$388="Actual")*('Data Sheet'!$H$5:$H$388))/1000)

I am trying to reduce the amount of ranges and use range names. Is there a limit to the number of range names as when the formula looks like

=SUMPRODUCT(((CM_Year=YEAR(CM_CurrentMonth))*('Data Sheet'!$B$5:$B$388<=CM_CurrentMonth)*(CM_Status="Actual")*('Data Sheet'!$H$5:$H$388))/1000)

I get the #NA error

Regards,

Jamie

 

[taylo40]

I have now sorted - apologies for any inconvenience