Or the non array formula

=SUMIF(A1:A100,"<="&99^99)




--
Regards,

Peo Sjoblom



"JMB" wrote in message
...
sum should ignore text. there is most likely #VALUE in your data. you
could
correct the error or try:

=SUM(IF(ISNUMBER(A1:A100), A1:A100))

array entered using Cntrl+Shift+Enter


"BruceA" wrote:

I have a spread sheet that I want to enter text in a field that is being
used
in a SUM. I want Excel to ignore the text and treat it as Missing Values
(or
zero). The SUM currently gets a #VALUE! error.