Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
De Jandon
 
Posts: n/a
Default Cell addressing using the content of another cell.

Hi there,
I will like to specify a function e.g. SUM to act on a cell whole address in
the content of another cell.

For instance, I want to sum Cell A12, and Ax and Ax where x is the content
of cell B12 for example. How do I reference a cell with the content of
another cell.

My task for requiring this is because I want to do the following:

Sum B12, B13, B14, B15.... Bxy to cell B4

The end of the B column to sum depends on the value in cell C2 for instance.
So if C2 contained 3, then, the sum function will be limited to SUM B12 and
B13, and B14 only. Then my result will be SUM (B4, B12:B14) in another cell
where the function resides

Likewise, had cell C2 contained 2, then my sum resuly would be SUM(B4,
B12:B13)

Thanks for your response.
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
Cell addressing using the content of another cell. Jandon Excel Worksheet Functions 1 March 30th 05 06:39 PM
Macro on cell content Riko Wichmann New Users to Excel 2 March 3rd 05 03:07 PM
Footnote wizard linked to cell content MVAND Excel Worksheet Functions 0 February 14th 05 07:11 PM
Indexing / Cell Addressing A_n_d_e_r_s Excel Discussion (Misc queries) 1 February 10th 05 12:47 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 06:42 PM.

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

About Us

"It's about Microsoft Excel"