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