thanks Frank
works vg

"Frank Kabel" wrote:

Hi
=SUMPRODUCT(--LEFT(A1:A10,4))

--
Regards
Frank Kabel
Frankfurt, Germany

"excelFan" schrieb im Newsbeitrag
...
hi all,
in the range myRange each cell contains 10 digits, how to sum the
first 4
digits to the left of each cell in this myRange, instead of adding
each cell
alone like:
=left(A1,4)+left(A2,4)+left(A3,4)+...
thanks for any help