Fixed references in tables

[excelos]

Hello

I know that to refer to a fixed column of a table you can do:
Table[A]:[A]

However how can you refer to a specific row? and row and column?

I have the table in column A:
1
2
3
...

And I want to put in the column B:
AVERAGE($A$1:A1) and dragged it down but it does not work, any idea?

Thanks!

 

[6StringJazzer]

When describing a problem it helps to explain what "does not work" means. What happens that is different than what you expect?

If you have a table, that means that you have headers in row 1, not data. Just use AVERAGE($A$2:$A2) starting in row 2. Works fine for me.

$scratch.xlsm
	A	B
1	First Column	Second Column
2	54	54.0
3	24	39.0
4	100	59.3
5	60	59.5
6	42	56.0
7	73	58.8
8	86	62.7
9	73	64.0
10	77	65.4
11	67	65.6
12	86	67.5
13	52	66.2
14	15	62.2
15	94	64.5
16	89	66.1
17	28	63.8
Table Average

Cell Formulas
Range	Formula
B2:B17	B2	=AVERAGE($A$2:$A2)

 

[excelos]

Thanks, well if you try to add a number in A18 the formula in B18 will work but the formula in B17 will change to an erroneous calculation

 

[6StringJazzer]

I see. I was able to reproduce that and don't know why it happens. But this formula solves the problem.

=AVERAGE($A$2:@[A])

where A is the heading of your first column, as shown in your example but may not be that way in your real file.