Remember Me?

#1
December 5th 04, 11:53 AM
 excelFan Posts: n/a
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
December 5th 04, 12:17 PM
 Frank Kabel Posts: n/a

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
December 5th 04, 12:33 PM
 excelFan Posts: n/a

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Anderson Lee Charts and Charting in Excel 1 December 28th 04 02:35 PM Steven Cheng Excel Discussion (Misc queries) 4 December 10th 04 10:12 PM SOkoll Charts and Charting in Excel 1 December 8th 04 06:43 AM Fred Evans Excel Discussion (Misc queries) 9 December 3rd 04 12:59 PM BdgBill Excel Discussion (Misc queries) 1 November 26th 04 08:03 AM

All times are GMT +1. The time now is 06:19 AM.