Try this

=SUM(A2:A4)+LEFT(A1,FIND("*",A1)-1)

If this post helps click Yes
---------------
Jacob Skaria


"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?