Help with Pivots

I do some calculations based on the value in the pivot, if theres no value (as the pivot dint fetch any rows), my calculation returns #REF! and then i am not able to sum the cells due to #REF! - How do i ignore all the #REF! and then sum?

Hi -

I tried using ISError and it worked.. Now i have a question:

I have this pivot formula

=IF(GETPIVOTDATA("Status",$A$3,"Account #",$A$16) <> "", IF(IF(ISERROR(GETPIVOTDATA("Status",$A$3,"Part #","A","Account #",$A$16,"Status","External Dependancy")),0,GETPIVOTDATA("Status",$A$3,"Part #","A","Account #",$A$16,"Status","External Dependancy")) = GETPIVOTDATA("Status",$A$3,"Account #",$A$16), 1, 0),0)

1) Now, i have to copy the formula to 2000 rows but $A$16 should change per the row number like $A$17, $A$18 etc.. How do i do that?

2) If there are no row data for the pivot, the above formula returns #REF! and i have to sum all the values and hence the sum becomes #REF! - How do i ignore the #REF! and just count the values alone.

Plz help?