Try this:

=SUMPRODUCT(--(LEFT(F1:F4;FIND("*";F1:F4)-1)))

--
Biff
Microsoft Excel MVP


"pierre" wrote in message
...
hi ...please help

i have the following formula :

=LEFT(F1;FIND("*";F1)-1)+LEFT(F2;FIND("*";F2)-1)+LEFT(F3;FIND("*";F3)-1)+LEFT(F4;FIND("*";F4)-1)

is there a way to make it shorter....??