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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top