Another Advanced Cell Reference
 

Hello,

A follow-up to my previous question. I would like to sum from cell A1
through cells in row 1, column A + indirect(example number). I am unable to
use the string =sum(A1:address(example code)) because the sum function will
not allow address() as an argument. Suggestions?

Thank you for your help.

Another Advanced Cell Reference
 

One way is to try it like this

In say, B1: =SUM(OFFSET(A1,,,10))
will return the sum of 10 col cells starting from the anchor cell A1,
ie equivalent to: =SUM(A1:A10)

Adapt the anchor cell and the "10" to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Popik" wrote:
Hello,

A follow-up to my previous question. I would like to sum from cell A1
through cells in row 1, column A + indirect(example number). I am unable to
use the string =sum(A1:address(example code)) because the sum function will
not allow address() as an argument. Suggestions?

Thank you for your help.

Another Advanced Cell Reference
 

Hi Popik,

In general, use a formula like;
=SUM(INDIRECT(ADDRESS(StartRowNo,StartColNo)) :
INDIRECT(ADDRESS(EndRowNo,EndColNo)))

So, to sum from A1 to O1
=SUM(INDIRECT(ADDRESS(1,1)) : INDIRECT(ADDRESS(1,15)))

Of course, you can use cell references instead of the values shown above.

Ed Ferrero
www.edferrero.com

Hello,

A follow-up to my previous question. I would like to sum from cell A1
through cells in row 1, column A + indirect(example number). I am unable
to
use the string =sum(A1:address(example code)) because the sum function
will
not allow address() as an argument. Suggestions?

Thank you for your help.

Another Advanced Cell Reference
 

Another one:

=SUM(A1:INDEX(A:A,n))

Where n is the numbers of cells to sum. For example:

n = 5 =SUM(A1:A5)
n = 10 =SUM(A1:A10)


--
Biff
Microsoft Excel MVP


"Popik" wrote in message
...
Hello,

A follow-up to my previous question. I would like to sum from cell A1
through cells in row 1, column A + indirect(example number). I am unable
to
use the string =sum(A1:address(example code)) because the sum function
will
not allow address() as an argument. Suggestions?

Thank you for your help.