I have a spreadsheet that is collating results from a Pivot table, that could have multiple responses.
I'm then collating those responses into a table, but I'm getting #REF! as sometimes the expected results may not appear?
e.g. In my Piviot table I may get Pass, but if Pass is not there I want to disaplay blank or 0, not #REF!
=GETPIVOTDATA("Pass/Fail", $A$17, "Pass/Fail","Pass")
So if Pass is not here, i'm getting #REF! = how can I get that resolved please??
I'm then collating those responses into a table, but I'm getting #REF! as sometimes the expected results may not appear?
e.g. In my Piviot table I may get Pass, but if Pass is not there I want to disaplay blank or 0, not #REF!
=GETPIVOTDATA("Pass/Fail", $A$17, "Pass/Fail","Pass")
So if Pass is not here, i'm getting #REF! = how can I get that resolved please??
Share with Messenger
4 Comments
sorted bySomething like this?
=IFERROR(GETPIVOTDATA("Pass/Fail", $A$17, "Pass/Fail","Pass"), "Fail")
That way if the GETPIVOTDATA errors, that should then trigger the IFERROR and return that result instead (edited)
IFERROR is the best way, or just specific cell references. Don't even have to put IFERROR, with the specific cell references, just a classic IF (edited)