I have a worksheet with 6 tables, each table ordered in date order, with a balance/total for each table in the final cell; and I want to sum those final balances and have that sum adjust dynamically as additional rows are added to each table.
I am only interested in the final value for each table, so after some research came up with the following (horrendous?) formula:
=INDEX(ABC1[[#All],[£]],COUNTA(ABC1[[#All],[£]]))+INDEX(ABC2[[#All],[£]],COUNTA(ABC2[[#All],[£]])) + the same for another 4 tables.
Is there a more elegant and simple way of achieving my goal?
I am only interested in the final value for each table, so after some research came up with the following (horrendous?) formula:
=INDEX(ABC1[[#All],[£]],COUNTA(ABC1[[#All],[£]]))+INDEX(ABC2[[#All],[£]],COUNTA(ABC2[[#All],[£]])) + the same for another 4 tables.
Is there a more elegant and simple way of achieving my goal?
Last edited:
