View Single Post
  #1   Report Post  
excelFan
 
Posts: n/a
Default 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