Create table automatically and add sum column and sum for each row

[jaryszek]

Hi Guys,

i have range and want to create table with:
1) additional column "Sum" based on dynamic number of columns from used range
2) Show subtotals.

Please Login or Register  to view this content.

It is ok but how to dynamiccaly sum each row based on number of columns?:

Screenshot_63.png



Best,
Jacek

[Haluk]

Place the following bit at the end of your code;

Please Login or Register  to view this content.

[jaryszek]

thank you Haluk.

it is only showing totals row but i want to get Sum for column A, B, C for each row.
Like in expected result:

Screenshot_64.png

So you see i have column "Sum" and there i have just added formula:

Please Login or Register  to view this content.

and problem is that this table is dynamic i can have different fields there added and somehow i have to include them into this formula.
To always catch column changes and allow user to input his values after creating table (and of course in the same time to calculate Sum for each row).

Best,
Jacek

[Haluk]

I understand the problem now...

Try the following code to see if it helps;

Please Login or Register  to view this content.

[sintek]

Please Login or Register  to view this content.

[jaryszek]

thank you very much it is very nice solution!

Jacek