SUMIF NOT #VALUE Question

[Dax Arroway]

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

 

[RagDyer]

Try this:

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

 

[Luke M]

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

Essentially forcing it to only look at numbers.

 

[Domenic]

Try...

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

Hope this helps!

Domenic
www.xl-central.com