| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Data Fill function to copy a Countif formula | Excel Worksheet Functions | |||
| Using Data Fill function to copy a Countif formula | Excel Worksheet Functions | |||
| we need to make it print one copy, not three | Excel Worksheet Functions | |||
| How do I copy a function formula? | Excel Worksheet Functions | |||
| How do I make a copy / paste function default? | Excel Worksheet Functions | |||
Linear Mode
