please help on this one...

[pierre]

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

 

[T. Valko]

Try this:

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

 

[pierre]

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

 

[Lars-Åke Aspelin]

=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

 

[T. Valko]

You're welcome. Thanks for the feedback!