How to Make Subtotal and Grand Total in Excel: A Step-by-Step Guide

Are you looking for a way to make subtotal and grand total calculations in Excel? Look no further! In this article, we will show you how to use the SUBTOTAL function to calculate subtotal and grand total for your dataset.

To get started, select any cell within your dataset. This will allow you to utilize the SUBTOTAL feature available in Excel. With this feature, you can perform special tasks such as calculating subtotals and grand totals.

Using the Subtotal Feature

The first step is to select the cells that contain the data you want to subtotal. In our example, we are using the cells F5:F7 for Product A. Next, enter the formula =SUBTOTAL(9,F5:F7) to calculate the sum of the sales for this product.

Understanding the SUBTOTAL Function

The SUBTOTAL function is a powerful tool that can be used to perform various mathematical operations. In our example, we are using it to calculate the subtotal for Product A. The formula takes two arguments: the first is the function number (9 in this case), which specifies the type of calculation you want to perform, and the second is the range of cells you want to subtotal.

Calculating Grand Total

In addition to calculating subtotals, you can also calculate grand total for all groups of products. To do this, enter the formula =SUBTOTAL(9,F5:F13) in cell F17. This will give you the grand total sales for all products.

In conclusion, using the SUBTOTAL function is a simple and effective way to make subtotal and grand total calculations in Excel. With this feature, you can perform various mathematical operations and calculate subtotals and grand totals for your dataset. Whether you are looking to analyze sales data or track inventory levels, the SUBTOTAL function is an essential tool that every Excel user should know how to use.

GrandTotal download

Download the sample file used in this article to practice making subtotal and grand total calculations in Excel. With this file, you can follow along with our step-by-step guide and learn how to use the SUBTOTAL function in your own projects. 'Download'