How to work with Table references

[kprabhupaul]

Dear All,

I have two tables.

In the first table I used cell references to get result (Total points gained up to the day)

Now I want to know how to get this by using Table references ..


Thanks in Advance ..

[AliGW]

As far as i know, table references reference whole columns, so you can't do a running total this way. However, if you use cell references as normal, the formula will extend down as you add new rows to the table, so there is no disadvantage as far as I can see. Why do you want/need to do this?

[kprabhupaul]

sometimes I will change the table columns to left or right according to my requirement ..

so then if I use cell references I will not get correct result.

and each time when I will change the columns, I have to modify the formula again (in cell references)

[AliGW]

What do you mean? If you move tables, the cell references will adjust to their new location.

[kprabhupaul]

not whole table,

just the columns only (within Table)

[AliGW]

You can move the columns about and the formula will adjust accordingly. See the attachment - I have moved your table, added a column, moved content - and the formula has adjusted accordingly. I see no issue here.

[kprabhupaul]

Ok, Just I misunderstood ..

Doubt Cleared ..

Thanks AliGW

[AliGW]

No problem - glad to have helped!