Remove #n/a from cell after vlookup

[mbesspiata]

I have a spreadsheet that workers can use a drop down in column a and by way of a vlookup function in columns b and c, it will place the unit of measure and cost per unit associated with the item entered in column A.
The problem I have is that I have copied my formulas down through 10 rows to allow for additional entries and if there is no entry, colums b and c give me the #N/A. The problem is that I have a total at the bottom which doesn't work with the #N/A in the b and c columns.
How can I get the total at the bottom to add the figures entered above while ignoring the #N/A?

9AA - Destruction of Routine, Non-Hazardous</SPAN>	per ton </SPAN>	$175.00</SPAN>
	#N/A</SPAN>	#N/A</SPAN>
	#N/A</SPAN>	#N/A</SPAN>
	#N/A</SPAN>	#N/A</SPAN>
	#N/A</SPAN>	#N/A</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>

thanks

Mike

 

[danzon]

use =IFERROR(yourformula,"")

 

[Smitty]

You can also test for the existence of a value in the lookup cell:

=IF(A1,VLOOKUP(A1,...),0)

HTH,

 

[mbesspiata]

Great. thanks for the help.