ExcelBanter - summing part of cells in a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - summing part of cells in a range (https://www.excelbanter.com/excel-discussion-misc-queries/1263-summing-part-cells-range.html)

excelFan

summing part of cells in a range

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))

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

excelFan

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

All times are GMT +1. The time now is 03:15 AM.