sunproduct...getting #N/A error

[jw01]

Hello

i have attached a sample workbook.

for some odd reason, the sumproduct is giving me a #N/A error.

i used the same workbook for last month and just copy pasted over the data. and the formula in the "Regional - Deals, Sales, Other" worksheet is showing all errors. can someone pls help!!!!

thx you so much

[NBVC]

You have a couple of #N/A in column D @ D780 and D807. Replace them.