=SUM(VALUE(SUBSTITUTE(A1:A4,"*","")))

This is an array formula that must be entered with:
CNTRL-SHFT-ENTER
rather than just the ENTER key.
--
Gary''s Student - gsnu200857


"pierre" wrote:

hello guys...
need help please

i have :

in cell A1 , this formula =1&""&"*"
in cell A2 ... 3
in cell A3... 4
in cell A4.... 2

i made an autosum in cell A5 (from A1 to A4) and the result is 9 although i
would like it to be 10

what should i do or modify.....any suggestion?