| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use the content of a cell in the sum (or other) functions
Example of what I want to achieve:
Column A has many rows with numbers. D1= a text cell that reads textually A1:A20 I am looking for a formula that will give me the sum of the VALUE that D1, gives me i.e. SUM(A1:A20). I do not want to define names for the range A1:A20 because the range changes frequently in in my particular spreadsheet I would have to redefine approx 200 names each time. Can anyone help me? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use the content of a cell in the sum (or other) functions
Try this:
=SUM(INDIRECT(D1)) Hope this helps. Pete On Apr 28, 3:01*pm, Michele Foley <Michele wrote: Example of what I want to achieve: Column A has many rows with numbers. D1= a text cell that reads textually A1:A20 I am looking for a formula that will give me the sum of the VALUE that D1, * gives me i.e. SUM(A1:A20). I do not want to define names for the range A1:A20 because the range changes frequently in in my particular spreadsheet I would have to redefine approx 200 names each time. Can anyone help me? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use the content of a cell in the sum (or other) functions
=SUM(INDIRECT(D1))
-- Gary''s Student - gsnu200781 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
| Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
