I NEED TO SUM NUMBERS ON A COLUMN THAT HAVE TEXT AND NUMBERS
 

i NEED TO TOTAL A COLUMN THAT HAS TEXT AND NUMBERS.
i USED THE SUM(A1:A20) AND EXCEL GAVE ME VALUE
iS THERE ANY WAY TO DO THIS

No need to shout!
SUM will ignore text so if you get a value error you must have a value error
in A1:A20.


--

Regards,

Peo Sjoblom


"FORMULA" wrote in message
...
i NEED TO TOTAL A COLUMN THAT HAS TEXT AND NUMBERS.
i USED THE SUM(A1:A20) AND EXCEL GAVE ME VALUE
iS THERE ANY WAY TO DO THIS

Try =SUM(IF(ISERROR(C10:C13),0,C10:C13)
enter it as an array formal with CTRL+SHIFT+ENTER

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Peo Sjoblom" wrote in message
...
No need to shout!
SUM will ignore text so if you get a value error you must have a value
error
in A1:A20.


--

Regards,

Peo Sjoblom


"FORMULA" wrote in message
...
i NEED TO TOTAL A COLUMN THAT HAS TEXT AND NUMBERS.
i USED THE SUM(A1:A20) AND EXCEL GAVE ME VALUE
iS THERE ANY WAY TO DO THIS

Or

=SUMIF(C10:C13,"<#VALUE!")

if the only errors are value errors

--

Regards,

Peo Sjoblom


"Bernard Liengme" wrote in message
...
Try =SUM(IF(ISERROR(C10:C13),0,C10:C13)
enter it as an array formal with CTRL+SHIFT+ENTER

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Peo Sjoblom" wrote in message
...
No need to shout!
SUM will ignore text so if you get a value error you must have a value
error
in A1:A20.


--

Regards,

Peo Sjoblom


"FORMULA" wrote in message
...
i NEED TO TOTAL A COLUMN THAT HAS TEXT AND NUMBERS.
i USED THE SUM(A1:A20) AND EXCEL GAVE ME VALUE
iS THERE ANY WAY TO DO THIS

Thank You
I don't know what I was thinking. Your answer made me review what I was
doing. You were right. Thank you again.

"Peo Sjoblom" wrote:

No need to shout!
SUM will ignore text so if you get a value error you must have a value error
in A1:A20.


--

Regards,

Peo Sjoblom


"FORMULA" wrote in message
...
i NEED TO TOTAL A COLUMN THAT HAS TEXT AND NUMBERS.
i USED THE SUM(A1:A20) AND EXCEL GAVE ME VALUE
iS THERE ANY WAY TO DO THIS