I have an VALUE error in one of the fields that I am trying to sum with
SUM('Q1:Q4'!D9). Is there anyway to ignore that value but still add the
others within the formula - perhaps to keep it so that when the VALUE error
is finally resolved into a number that it will also include that cell as part
of the sum?