Somehow I miss something. When making an Excel-table from a datatable you can mark 'Total' in the design. But then only the total of the last column appears (and it's a subtotal, but that works good when you filter some data). I thought there was a way to easily add the totals for the other columns as well, and the same for the row totals. But kind find it (anymore).
See attached file where I explain with dataset and screenshot.
Is there an answer to do this totalling all at once?
Hi Frans
You can select cell N47 (where the subtotal is) and drag the little black dot (at the bottom-right corner of the cell) to the other columns to fill in the subtotal.
Another way is to select the cells C47:N47 and click the AutoSum from the ribbon.
As for the row total, if you enter a formula, it will auto fill the entire column unless that column contains any non-formula. You can also use the AutoSum method.
Sunny
Thanks Sunny! It are the most easy things that sometimes don't come up..... I started with the copy-paste and that's not the trick here. Maybe that's why I didn't try the 'drag' solution. And for the row total: that one is indeed already the one we used, but I was thinking maybe some other solution is also possible.
This all started in a lesson, where at first (before making the Excel-table) you can autosum everything by selecting the data. When the client did this in the Excel-table (which in my opinion was a logical way of thinking) this didn't work anymore (only zero's appeared) and so we were discussing the right way to totalize columns and rows in these Excel-tables.
Excel always surprises me in one way or the other 😉
Hi Frans
If you want to sum all columns and rows in one-go, just select the data plus one extra column to the right and one extra row to the bottom.
Now click the auto sum button. This will also work for non-table.
Hope his helps.
