Address F(x)

[briank]

I notice that I cannot use the "address" function as part
of a mathmatical function like "sum".
For example:
A B C
Row 1 4 5 3

=sum(ADDRESS(CELL("row",A2)-1,CELL("col",A3)):ADDRESS(CELL
("row",C2)-1,CELL("col",C80)))

Any thoughts on how I can get this to work?
Thanx.

 

[Stephen Bye]

The ADDRESS function returns a cell address as text.
You will need to use the INDIRECT function to convert that to a reference.

 

[Harlan Grove]

I notice that I cannot use the "address" function as part
of a mathmatical function like "sum".
For example:
A B C
Row 1 4 5 3

=sum(ADDRESS(CELL("row",A2)-1,CELL("col",A3)):ADDRESS(CELL
("row",C2)-1,CELL("col",C80)))

Another alternative that requires the fewest possible function calls.

=SUM(OFFSET(A1,CELL("Row",A2:C2)-2,CELL("Col",A3:C80)-1,ROWS(A2:C2),
COLUMNS(A3:C80)))