Hi, I have data which has been formatted as a table - how can I use subtotals with this

Hi,

You would use it just as you would normally. Place the cursor below the cell you want to subtotal and typ:

=subtotal(9,<your range here>)

The above example uses the sum. something like =subtotal(9, A1:B12).
When you filter the data the output will be filtered as well.

Maurice

Hi Viv,

as far as I know, you need to convert your table into a range first. (Table Tools - Tools - convert to range)

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

I've always just used the Subtotal button on the Data tab but you can't use that in a table. I'll try the other way.

Thanks