sum formula that ignores none numbers

[plost33]

I need a formula that will sum A1:A100 although some of the values in that range are text.

must be a formual to only add the numerical values int he range and ignore cells with non numerical characters.

hope someone can assist.

 

[shg]

The SUM function ignores text, including text that looks like numbers.

 

[Aladin Akyurek]

I need a formula that will sum A1:A100 although some of the values in that range are text.

must be a formual to only add the numerical values int he range and ignore cells with non numerical characters.

hope someone can assist.

=SUM(A1:A100)

would ignore all non-numeric values (though not the error values like #REF!, etc.).

 

[T. Valko]

I need a formula that will sum A1:A100 although some of the values in that range are text.

must be a formual to only add the numerical values int he range and ignore cells with non numerical characters.

hope someone can assist.

The SUM function will ignore text entries.

=SUM(A1:A100)

This version will also ignore error values:

=SUMIF(A1:A100,"<1E100")

 

[Armando Montes]

Try: SUM(A1:A100)

 

[plost33]

oopss..i wasnt actually using sum..i was using a1+a2+a3..ect... works now. thanks

 

[Aladin Akyurek]

oopss..i wasnt actually using sum..i was using a1+a2+a3..ect... works now. thanks

The + operator in A1+A2 attempts to read or if needed coerce
what is in A1 and A2 into numbers in order to proceed. Upon failing on true text,
it will end up in a #VALUE!... This holds for all of the math operators
like -, *, ^, etc.