|Subject:||IF #REF then display 0|
|Date:||28 Jun 2006|
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.