Hello Pierre,
a1 has a text there, that is the reason excel return 9 on the =sum(a1:a4)

looking for you example a solution could be:

=left(a1,1)+sum(a2:a4)

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"pierre" escreveu:

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?