| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using range with INDIRECT and ROW()
I am setting up a spreadsheet that with add columns in a row, but need
it to be applicable to various rows, I hacked this formula together so far: =SUM(INDIRECT("A"&ROW()), INDIRECT("B"&ROW()), INDIRECT("C"&ROW()), INDIRECT("D"&ROW()), INDIRECT("E"&ROW())) Anyone have a suggestion how to improve this formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using range with INDIRECT and ROW()
This will do the same thing:
=SUM(INDEX(A:E,ROW(),)) -- Biff Microsoft Excel MVP "Paranormal Gravy" wrote in message ... I am setting up a spreadsheet that with add columns in a row, but need it to be applicable to various rows, I hacked this formula together so far: =SUM(INDIRECT("A"&ROW()), INDIRECT("B"&ROW()), INDIRECT("C"&ROW()), INDIRECT("D"&ROW()), INDIRECT("E"&ROW())) Anyone have a suggestion how to improve this formula? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using range with INDIRECT and ROW()
Could you please explain what do you want to do?
"Paranormal Gravy" wrote: I am setting up a spreadsheet that with add columns in a row, but need it to be applicable to various rows, I hacked this formula together so far: =SUM(INDIRECT("A"&ROW()), INDIRECT("B"&ROW()), INDIRECT("C"&ROW()), INDIRECT("D"&ROW()), INDIRECT("E"&ROW())) Anyone have a suggestion how to improve this formula? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using range with INDIRECT and ROW()
On Jan 30, 9:43*pm, "T. Valko" wrote:
This will do the same thing: =SUM(INDEX(A:E,ROW(),)) -- Biff Microsoft Excel MVP "Paranormal Gravy" wrote in message ... I am setting up a spreadsheet that with add columns in a row, but need it to be applicable to various rows, I hacked this formula together so far: =SUM(INDIRECT("A"&ROW()), INDIRECT("B"&ROW()), INDIRECT("C"&ROW()), INDIRECT("D"&ROW()), INDIRECT("E"&ROW())) Anyone have a suggestion how to improve this formula? That worked perfectly, thank you so much. And all I want to do is create a formula that can be "copied and pasted" into multiple cells in a column to add up the previous columns, without having to change the formula for each row. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using range with INDIRECT and ROW()
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Paranormal Gravy" wrote in message ... On Jan 30, 9:43 pm, "T. Valko" wrote: This will do the same thing: =SUM(INDEX(A:E,ROW(),)) -- Biff Microsoft Excel MVP "Paranormal Gravy" wrote in message ... I am setting up a spreadsheet that with add columns in a row, but need it to be applicable to various rows, I hacked this formula together so far: =SUM(INDIRECT("A"&ROW()), INDIRECT("B"&ROW()), INDIRECT("C"&ROW()), INDIRECT("D"&ROW()), INDIRECT("E"&ROW())) Anyone have a suggestion how to improve this formula? That worked perfectly, thank you so much. And all I want to do is create a formula that can be "copied and pasted" into multiple cells in a column to add up the previous columns, without having to change the formula for each row. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| Using Indirect to set a range | Excel Worksheet Functions | |||
| using indirect to sum range | Excel Worksheet Functions | |||
| Indirect Range | Excel Worksheet Functions | |||
| Indirect range in SUMPRODUCT? | Excel Discussion (Misc queries) | |||
Linear Mode
