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?

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?

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?

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.

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.