How do I tell Excel to "ignore" invalid numeric data?

B

BruceA

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.
 
J

JMB

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
 
Top