D
dicko1
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
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