In function =Sum(A#:B#) how can I make # a formula so I can copy p
 

If I use the function =SUM(A#:F#), I will get a sum for a matrix. Now I would
like to substitute the #'s with formulas which calculate the row for each
column (A,F). Thereafter, I would like to copy the function with the formulas
to other cells.

In function =Sum(A#:B#) how can I make # a formula so I can copy p
 

Look in Excel help for the INDIRECT function.
--
David Biddulph

"No expert" <No wrote in message
...
If I use the function =SUM(A#:F#), I will get a sum for a matrix. Now I
would
like to substitute the #'s with formulas which calculate the row for each
column (A,F). Thereafter, I would like to copy the function with the
formulas
to other cells.

In function =Sum(A#:B#) how can I make # a formula so I can copy p
 

Hi

Try
=SUM(INDIRECT("A"&X1&":F"&X2))

Where X1 and X2 are the cell references containing the formulae that
calculate the row numbers required
--

Regards
Roger Govier

"No expert" <No wrote in message
...
If I use the function =SUM(A#:F#), I will get a sum for a matrix. Now I
would
like to substitute the #'s with formulas which calculate the row for each
column (A,F). Thereafter, I would like to copy the function with the
formulas
to other cells.