I have a situation where my GETPIVOTDATA returns nothing (#REF) because that
reference isn't in the source data, but I want a 0, to appear when this
happens rather than a #REF. It seems like there is a syntax that I could use
in my formula to make this happen.

Help?

--
Sunny FL