Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 5th 04, 11:53 AM
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



  #2   Report Post  
Old December 5th 04, 12:17 PM
Frank Kabel
 
Posts: n/a
Default

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

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
To get a lot of charts that refer to different cells Anderson Lee Charts and Charting in Excel 1 December 28th 04 02:35 PM
HTML_Control Range name Steven Cheng Excel Discussion (Misc queries) 4 December 10th 04 10:12 PM
How do you change the size of a range of cells in a column/row SOkoll Charts and Charting in Excel 1 December 8th 04 06:43 AM
Protected cells -automatically format to a different color Fred Evans Excel Discussion (Misc queries) 9 December 3rd 04 12:59 PM
Cells losing formatting BdgBill Excel Discussion (Misc queries) 1 November 26th 04 08:03 AM


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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017