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?