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

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

thank you sir VERY MUCH...........just keep it on ;)

On Thu, 18 Jun 2009 08:12:05 -0700, pierre
wrote:

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

Try this formula:

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

Note: This is an array formula that should be entered by
CTRL+SHIFT+ENTER rather than just ENTER.

Hope this helps / Lars-Åke

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"pierre" wrote in message
...
thank you sir VERY MUCH...........just keep it on ;)