Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is there a way to set up subtotals in a worksheet that are automatically updated, without using pivot tables?

April 26, 2017automatically Pivot subtotals tables updated worksheet

0

0 Posted

Is there a way to set up subtotals in a worksheet that are automatically updated, without using pivot tables?

1 Answer

0

0 Posted

It is possible to set up your worksheet to compute totals or averages for changing data using data tables and defined names. The way to do it is illustrated and explained in our free sample workbook. You are welcome to download our Automatic Subtotals example workbook (27K).