I'm trying to SUM a range Q3:Q33, but this range has values in it that get
calculated from other places that will be calculated through time. In the
last few cells of the range I have "#VALUE" messages. How do I SUM Q3:Q33
and ignore the #VALUEs?

I'm trying =SUMIF(Q3:Q33,"*",Q3:Q33), but this gives me a sum of 0.
and =SUMIF(Q3:Q33,"<#VALUE",Q3:Q33), gives me #VALUE.

Thanks in advance for your help.
--Dax
--
I would give my left hand to be ambidextrous!

Try this:

=SUMIF(Q3:Q33,"<"&99^99)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dax Arroway" wrote in message
...
I'm trying to SUM a range Q3:Q33, but this range has values in it that get
calculated from other places that will be calculated through time. In the
last few cells of the range I have "#VALUE" messages. How do I SUM Q3:Q33
and ignore the #VALUEs?

I'm trying =SUMIF(Q3:Q33,"*",Q3:Q33), but this gives me a sum of 0.
and =SUMIF(Q3:Q33,"<#VALUE",Q3:Q33), gives me #VALUE.

Thanks in advance for your help.
--Dax
--
I would give my left hand to be ambidextrous!

You could trick it by doing something like
=SUMIF(Q3:Q33,"<999999999999")

Essentially forcing it to only look at numbers.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Dax Arroway" wrote:

I'm trying to SUM a range Q3:Q33, but this range has values in it that get
calculated from other places that will be calculated through time. In the
last few cells of the range I have "#VALUE" messages. How do I SUM Q3:Q33
and ignore the #VALUEs?

I'm trying =SUMIF(Q3:Q33,"*",Q3:Q33), but this gives me a sum of 0.
and =SUMIF(Q3:Q33,"<#VALUE",Q3:Q33), gives me #VALUE.

Thanks in advance for your help.
--Dax
--
I would give my left hand to be ambidextrous!

Try...

=SUMIF(Q3:Q33,"<#VALUE!")

Hope this helps!

Domenic
www.xl-central.com

In article ,
Dax Arroway wrote:

I'm trying to SUM a range Q3:Q33, but this range has values in it that get
calculated from other places that will be calculated through time. In the
last few cells of the range I have "#VALUE" messages. How do I SUM Q3:Q33
and ignore the #VALUEs?

I'm trying =SUMIF(Q3:Q33,"*",Q3:Q33), but this gives me a sum of 0.
and =SUMIF(Q3:Q33,"<#VALUE",Q3:Q33), gives me #VALUE.

Thanks in advance for your help.
--Dax