Mac Forum / Applications / Excel / March 2006

Hi Jessica -

The problem is that the illegal characters (<space>livres) prevent the cell
content from being used as values. AFAIK, there is no single function,
including  SUM & SUMIF (I believe that is the one you referred to as SUMA)
that will pick digits out of a text string for computation.

There are probably a few more complex expressions that will extract the
digits, convert them to values & perform the summing, but I would be more
likely to consider using Data>Text to Columns to create the numerical column
(600, 400, 800) separate from the text column (livres, ", "). Then, summing
the column of values would present no problem. In fact, I'd probably just
caption that column as "Livres" and save myself a lot of redundant data
entry... Although I must admit I have no idea what a 'livre' is :)

HTH |:>)

On 3/20/06 4:05 PM, in article
1142888752.403913.236710@e56g2000cwe.googlegroups.com, "jexel"
<jessicagillies@gmail.com> wrote:

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