I have a formula the multiplies two cells and adds that product to a
referenced cell from another worksheet.

For example:

=T9*L14+GETPIVOTDATA("Billing Amount",'Labor
Pivot'!$A$6,"TradeCode","F04")

The problem is that when the Pivot Table is changed, the data that the
formula is looking for may not be there anymore and the formula cell
displays #REF!. Is there a way for my formula to still display the
product of T9*L14 and if no data can be found from the Pivot Table it
ignores that part of the formula or equates it to 0?

Thanks,
Ryan