make the #N/A from Lookups act like Zeros in sum calculations

[JB1981]

I've got a long Hlookup pulling values based on Unit Quantities and multiplying them by the lookup value, and vertical rows with multiple Hlookups with a cell adding all these values together at the bottom.

If I dont fill in one of the Hlookup cells, i get the #N/A that throws off the subtotal cell at the bottom using =Sum(C1:C5)

Is there any way to make the #N/A not appear if the formula returns this value, or have the sum calculation see a #N/A as a zero?

Thanks for the help!!!
JB

[JB1981]

Of course once you ask the question you find a way to answer it yourself. Found this piece of code from a unrelated topic that solves the problem incase someone else wants to know the answer to this question too.

You simply put an If statement that looks to see if you filled in a value for the Hlookup to calculate, and if you didnt it fills it in an empty value.

Brilliant!

=IF(B6<>"",HLOOKUP(B6,D4:K6,2,0)*B6,"")