Full column relative referencing down the column

[pban92]

I need to SUM entire column of A:A, B:B, C:C, etc. in AA1, AA2, AA3 and so on. Is there way to make a cell reference of =SUM(A:A) down the column AA starting at AA1 and AA2 and so on and get the sum values of B:B, C:C and so on? Thanks.

 

[DanteAmor]

Try this

Dante Amor
	A	B	C	D	E																					Z	AA
1	1	2	3	4																							13
2	3	2	3	1																							19
3	4	8	6	4																							21
4	5	7	9	9																							18
5
dam2

Cell Formulas
Range	Formula
AA1:AA4	AA1	=SUM(INDEX(A:Z,0,ROW()))

 

[pban92]

Try this

Dante Amor
	A	B	C	D	E																					Z	AA
1	1	2	3	4																							13
2	3	2	3	1																							19
3	4	8	6	4																							21
4	5	7	9	9																							18
5
dam2

Cell Formulas
Range	Formula
AA1:AA4	AA1	=SUM(INDEX(A:Z,0,ROW()))

Thank you so much!