If you use the Sum function in the same range, the result will be 720. The range (ref1) in that formula is C2:C13. We must pay attention to the one in cell C14. Please refer to the second column in the table above. In the following Excel formula example, I have used the function number 9 (sum). Exclude Subtotals in Subtotal Function in Excel You can understand the difference in the examples below. The first group from 1 to 11 and the second group from 101 to 111. There are two groups of function numbers. Syntax: SUBTOTAL(function_num,ref1,…) Function Nameįunction Numbers to Exclude Filtered-Out Rows &

Aggregate Only the Visible Rows in the Subtotal Function Excel.

Exclude Subtotals in Subtotal Function in Excel.

It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007. It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface. You can use Office 2007/2010/2013/2016 immediately without any training.

Then you will view the Subtotal button there.

If you did not installed Classic Menu for Office on your computer, this tip will help you find out the Subtotal Button in Microsoft Excel 2007/2010/2013/2016/2019 Ribbon: Get Subtotal Button in Ribbon if you do not have Classic Menu for Office

Click the Data drop down menu in main menus įigure 1: The Subtotal button in Classic Menu.

If you have installed it on your computer, you can find out the Subtotal Button quickly: It aims to bring back the classic menu interface into new Ribbon of Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365. Not used to Microsoft Excel 2007/2010/2013/2016/2019 Ribbon? Adopted using habits are not valid in new Ribbon? Classic Menu for Office is designed to solve these problems. Seek for the Subtotal Button at ease if you have Classic Menu for Office

Classic Menu for Office Home and Business.

Classic Menu for Office 2007 Applications.

Multiple subtotals in excel 2010