Replace getpivotdata's "#REF!" with "0"?

[Guest]

I am linking a spreadsheet to a pivot table. I am using getpivotdata to return a value for the total of an account, that may or may not be in the pivot table. One month the account may have a balance, the next month it may not. When it does not have a balance it will not show up in my pivot table, in this instance it will return #Ref! to my spreadsheet. This is the correct response; however, can I do something like "IF getpivitdata ='s #Ref! , return 0.
My spreadsheet can add 0's but it can't add #Ref!'s

 

[Debra Dalgleish]

You can use the ISERROR function:


=IF(ISERROR(GETPIVOTDATA("Units",$A$3,"Item","Pencils")),"",GETPIVOTDATA("Units",$A$3,"Item","Pencils"))