Using Sumproduct to Aggregate and #NA values

[BlueRhinos]

Objective: I using a sumproduct formula to aggregate data from 2 columns in another sheet, 1 of which contains #NA values. Do the #NA values cause the sumproduct formula not to work and if yes, how can I convert the #NA's to something else. Here's the formula producing some #NA's.

Formula: VLOOKUP(D12,Worksheet1$F$1:$G$407,2,FALSE)

Thanks for any insight!

 

[PaddyD]

what version of excel are yuo using, if 2007, check out iferror(), if not:

http://www.mrexcel.com/forum/showthread.php?t=59718