Excel Subtotal Function

Method 1 - Calculate the Average Using Excel's SUBTOTAL Function. To find the average, follow these steps Modify the Data Set Modify the data set to perform the average operation. Enter the SUBTOTAL Function In Cell C17, enter the SUBTOTAL function. Use 1 as the first argument to indicate the average. The formula becomes

Learn how to use the SUBTOTAL function in Excel to ignore rows hidden by a filter or manually hidden rows. See examples, tips and automatic subtotals with tables and outlines.

Learn how to use the SUBTOTAL function in Excel to return a subtotal in a list or database. See the syntax, arguments, examples, and remarks for different function_num values.

The SUBTOTAL Function works exactly the same in Google Sheets as in Excel SUBTOTAL Examples in VBA. You can also use the SUBTOTAL function in VBA. Type application.worksheetfunction.subtotalfunction_num,reh1 Executing the following VBA statements

The Excel SUBTOTAL function is designed to run a given calculation on a range of cells while ignoring cells that should not be included. SUBTOTAL can return a SUM, AVERAGE, COUNT, MAX, and others see complete list below, and SUBTOTAL function can either include or exclude values in hidden rows.

The SUBTOTAL function is a built-in function in Excel that is categorized as a MathTrig Function. It can be used as a worksheet function WS in Excel. As a worksheet function, the SUBTOTAL function can be entered as part of a formula in a cell of a worksheet.

See the subtotal of values with this simple Excel function.

Learn how to subtotal in Excel using simple methods ranging from manual Excel functions to Excel VBA-based automation. Compare the SUBTOTAL, AGGREGATE, and Subtotal tools with examples and illustrations.

Learn how to use SUBTOTAL function in Excel to calculate values in filtered or hidden rows, and to ignore nested subtotals. See syntax, uses, and examples of different function numbers and arguments.

Learn how to use the SUBTOTAL function in Excel to calculate results on filtered or visible cells only. See the different calculation types, arguments, tips and tricks, and a macro to create a summary table.