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
|