help with errors with Sum function
 

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?

help with errors with Sum function
 

hotelmasters wrote:
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?

Are you sure that's a valid SUM formula?

help with errors with Sum function
 

yes. it references all cells D9 in worksheets Q1 through Q4

"Paul Lautman" wrote:

hotelmasters wrote:
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?

Are you sure that's a valid SUM formula?

help with errors with Sum function
 

hotelmasters wrote:
yes. it references all cells D9 in worksheets Q1 through Q4

"Paul Lautman" wrote:

hotelmasters wrote:
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?

Are you sure that's a valid SUM formula?

Ahh that's why it faild on my machine as I didn't have those worksheets!