![how to add multiple rows in excel and keep column totals how to add multiple rows in excel and keep column totals](https://www.extendoffice.com/images/stories/doc-excel/show-multiple-grand-totals/doc-show-multiple-grand-totals-1.png)
In this example, we displayed two Average functions in the first row. Subtotals in the same row will always be of the result of the same function. It’s such a simple step, but the return is huge! The first shows two averages and the second shows the total number of units in stock. Uncheck the Replace Current Subtotals option.
![how to add multiple rows in excel and keep column totals how to add multiple rows in excel and keep column totals](https://i.stack.imgur.com/rDs8U.png)
![how to add multiple rows in excel and keep column totals how to add multiple rows in excel and keep column totals](https://cdn.ablebits.com/_img-blog/excel-sum/sum-entire-row-excel.png)
How easy was that? With just a few clicks, you generated the average price and stock for each product category.