Why doesn't Excel do this simple task??

[InterstateRentals]

A simple table of numbers ... I want to SUM the values by row1, row2, ..., row5.

I want to list the results in cells A8, B8, ...., E8.

Enter the SUM formula in A8, B8 and C8 ... then drag. Excel provides WRONG FORMULAS in D8 and E8. I also tried using absolute, no help.

Can somebody please explain why Excel will not fill in this formula correctly? It seems as basic as it can get, but ....


EXAMPLE - WORKBOOK.xlsx

[popipipo]

=SUM(INDIRECT("A"&COLUMN()&":H"&COLUMN()))
Try this one

[shg]

You need to drag the formula down, not right, if you want the references to adjust down.

[Jonmo1]

Try

=SUM(OFFSET($A1:$X1,COLUMNS($A:A)-1,0))

[InterstateRentals]

You all are so helpful. Thank you for the fantastic advice!! Much appreciated!!!

[Jonmo1]

You're welcome.