Mixed cell reference
Thank you so much! I did not get the exact results from your formula, but
modified it to =SUM(INDEX(MP1,ROW()):INDEX(MP2,ROW())). Your formula yielded
the correct results for the row immediately BELOW the row in which the
formula appeared.
--
Bill
"RagDyeR" wrote:
Try this:
=SUM(INDEX(MP1,ROWS($1:1)):INDEX(MP2,ROWS($1:1)))
Careful how you rename your ranges!
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Bill" wrote in message
...
Would like to name a specific column BUT allow the row to change.
Example: columns named "MP1" and "MP2" with intervening columns; rows 1 to
3
MP1 ... MP2 ANSWER Formula
1 21 22 23 SUM(MP1 1:MP2 1)
2 5 6 7 SUM(MP1 2:MP2 2)
3 0 2 9 SUM(MP1 3:MP2 3)
The SUM formulas above are not valiid, but I hope the reader can suggest
formulas that are valid.
Reason: Next year the locations of MP1 and MP2 might change but the rows
will not and I would like to simply delete the current names MP1 and MP2 and
name some new columns MP1 and MP2 without changing the formulas.
--
Bill
|