Sumproduct Returns #NAME?

[goss]

Hi all,

Using Excel 2010.

I'm trying to summarize some data to create stacked area charts
Where data points exist, I get the correct results. But where datapoints are missing, I keep getting a #NAME? error.

I tried this

=IF(OR(SUMPRODUCT((Data!$B$2:$B$357=$B10)*(Data!$C$2:$C$357=C$9)*(Data!$F$2:$F$357))=0,ISERROR(SUMPRODUCT((Data!$B$2:$B$357=$B10)*(Data!$C$2:$C$357=C$9)*(Data!$F$2:$F$357)))),N/A(),SUMPRODUCT((Data!$B$2:$B$357=$B10)*(Data!$C$2:$C$357=C$9)*(Data!$F$2:$F$357)))

and this

=IF(ISERROR(SUMPRODUCT((Data!$B$2:$B$357=$B20)*(Data!$C$2:$C$357=C$9)*(Data!$F$2:$F$357))),NA(),IF(SUMPRODUCT((Data!$B$2:$B$357=$B20)*(Data!$C$2:$C$357=C$9)*(Data!$F$2:$F$357))=0,N/A(),SUMPRODUCT((Data!$B$2:$B$357=$B20)*(Data!$C$2:$C$357=C$9)*(Data!$F$2:$F$357))))

What am I doing wrong?

 

[shawnhet]

Just a simple typing error here it seems - N/A() should read NA().

Cheers,

 

[goss]

Thanks Shawnhet,

That did resolve the problem.