sum function ignoring text

[jexel]

Can someone please tell me how to use the sum function to add values in
cell that have text in them as well? i know excel for pcs have the
option of SUM and SUMA, how do I add just the numbers and ignore the
text?

 

[JE McGimpsey]

Can someone please tell me how to use the sum function to add values in
cell that have text in them as well? i know excel for pcs have the
option of SUM and SUMA, how do I add just the numbers and ignore the
text?

SUM()ignore text.

A1: 3
A2: hello
A3: 4
A4: =SUM(A1:A3) ===> 7

 

[jexel]

No, more like this:

A1: 600 livres
A2: 400 livres
A3: 800 livres

When I put a SUM function in A4, it comes up as NAME#

PLease help!

 

[Francis Hookham]

I take it livres are old French currency

You could Custom Format the Cells like this:
0" livres"
or even
0" livres";-0" livers";
if you have minus values
then you would be entering numerals which can be =sum( ) in the usual way
but no good if there is a mixture of currancy

Francis Hookham