IF #REF then display 0
 

I am using a PivotTable, and using the GETPIVOTDATA formula to popluate
data on a separate worksheet. The colums are days of the month, but if
i don't have any data for that date it gives me a #REF. Is there a way
i can include with my GETPIVOTDATA statement, that if it shows an error
or #REF, it will displya a 0 or leave it blank, that way it doesn't
mess up with the other data.

Let me know if you need any additional information.

IF #REF then display 0
 

How about

=if(ISERROR(getpivotdata()),0,getpivotdata())


" wrote:

I am using a PivotTable, and using the GETPIVOTDATA formula to popluate
data on a separate worksheet. The colums are days of the month, but if
i don't have any data for that date it gives me a #REF. Is there a way
i can include with my GETPIVOTDATA statement, that if it shows an error
or #REF, it will displya a 0 or leave it blank, that way it doesn't
mess up with the other data.

Let me know if you need any additional information.