Address F(x)

  • Thread starter Thread starter briank
  • Start date Start date
B

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.
 
The ADDRESS function returns a cell address as text.
You will need to use the INDIRECT function to convert that to a reference.
 
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)))
Click to expand...

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)))
 
Back
Top