| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To get a lot of charts that refer to different cells | Charts and Charting in Excel | |||
| HTML_Control Range name | Excel Discussion (Misc queries) | |||
| How do you change the size of a range of cells in a column/row | Charts and Charting in Excel | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
| Cells losing formatting | Excel Discussion (Misc queries) | |||
Hybrid Mode
