software

Hi all,As I read on another thread, I tried to use the conditional formatting
in order to eliminate #REF error (due to lack of a certain item in
pivot, that I'm going to reference with GETPIVOTDATA) but I still have
the #REF as the result of sum several items if one of it is #REF.
Is there any solution to solve this issue?

Thanks in advance,
regards,

Pat--
pat59
------------------------------------------------------------------------
pat59's Profile: www.excelforum.com/member.php...oamp;userid=31861
View this thread: www.excelforum.com/showthread...hreadid=517822You could use an IF formula to test the result, e.g.:

=IF(ISERROR(GETPIVOTDATA(quot;Unitsquot;,$A$6,quot;Regionquot;,quot;On tarioquot;)),0,
GETPIVOTDATA(quot;Unitsquot;,$A$6,quot;Regionquot;,quot;Ontarioquot;))

pat59 wrote:
gt; As I read on another thread, I tried to use the conditional formatting
gt; in order to eliminate #REF error (due to lack of a certain item in
gt; pivot, that I'm going to reference with GETPIVOTDATA) but I still have
gt; the #REF as the result of sum several items if one of it is #REF.
gt; Is there any solution to solve this issue?

--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html
thanks, Debra!
bye--
pat59
------------------------------------------------------------------------
pat59's Profile: www.excelforum.com/member.php...oamp;userid=31861
View this thread: www.excelforum.com/showthread...hreadid=517822