SUBTOTAL Function in Excel

SUBTOTAL Function in Excel

In this post, you will learn about the SUBTOTAL Function in Excel, how to use it in – with the excel spreadsheets.

Syntax

=SUBTOTAL (function_num, ref1, ref2, ...)

This syntax initially has two arguments

function – This argument holds the function that you want to perform

ref(1,2,..) – This holds the number or the data on which you want to perform the function, this argument can be used according to the amount of data.

How does the SUBTOTAL Function work?

  • It performs the subtotal of the data with the selected math formulas like  SUM, AVERAGE, COUNT, MAX, PRODUCT, and other functions.
  • To start with, enter the data in an excel spreadsheet. In a new cell enter the syntax and select what function you want to use from the drop-down list.
SUBTOTAL Function in Excel
  • Highlight the data to include it in the syntax. You can select the data individually or as a group.
SUBTOTAL Function in Excel
SUBTOTAL Function in Excel
SUBTOTAL Function in Excel
  • Press enter to display the Subtotal.
SUBTOTAL Function in Excel
  • The SUBTOTAL Function ignores any inside SUBTOTAL formulas used within the formula in the excel sheet to prevent double counting.
SUBTOTAL Function in Excel
SUBTOTAL Function in Excel
SUBTOTAL Function in Excel
SUBTOTAL Function in Excel

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...