summing part of cells in a range

[Guest]

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

 

[Frank Kabel]

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

 

[Guest]

thanks Frank
works vg

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