June 11, 2020
Hi there, I have a workbook with multiple worksheets that have the worksheet's data subtotals reporting in cells that change depending on how many rows are entered in each worksheet. Each worksheet will have rows added and deleted with each use and I need some way of taking the page's totals and having them reflected on a master totals sheet. Can that be done if there is never a consistent row or cell to point to that houses the subtotal for each individual worksheet?
December 7, 2016
If your data is in Excel tables and you have activated the option to show the Total Row (Table Design, Table Style Options), you can reference this total by using a formula like below. In this example you will get the totals for the column named Column2.
If you want to get the whole row, then you use this formula.
If you want the totals for a range of columns, then you use this formula.
If you don't use Excel tables you can always reference to a column range, like below example.
These are just some basic examples.
Hope it helps you forward.