add numeric columns

I have a table that sums an account balance by company. I want to add a grand total column, but I need it to be dynamic since there may be more (or less) companies added in the future.

Current Data

What formula can I use that will make the addition fluid and change whenever companies are added or removed?

Desired Output

add columns.xlsx

Transformation

Accepted answers

Qiu

@tiverson
There is an option "Total Column" in the Cross Tab. so we can do a Transpose then Cross Tab back the data as below.
This is absolutely dynamic😁

0511-tiverson.yxmd

All comments

DataNath

I believe this should work? Let us know if not! Had to trim off the original grand totals to regenerate them within.

Dynamic grand totals.yxmd

Qiu

@tiverson
There is an option "Total Column" in the Cross Tab. so we can do a Transpose then Cross Tab back the data as below.
This is absolutely dynamic😁

0511-tiverson.yxmd

DataNath

Oh boy, how did I miss that @Qiu? 😂

Every day is a school day!

Qiu

@DataNath
Being the similar situation many times. 🤣

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703