PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO DO SUBTOTAL IN EXCEL?

INTRODUCTION

Subtotal is required many times in our reports and we have to do this manually by inserting a row and then apply the addition on the data.

SUBTOTAL in excel provides us an easy way to do this automatically.

Example:

Suppose we have a data which shows the number of vehicles sold in april and may and four days of week.

We’ll be totalling the number of vehicles sold in one month and subtotal it.

 

 
 

BUTTON LOCATION FOR SUBTOTAL IN EXCEL

group ungroup in excel
BUTTON LOCATION

STEPS TO DO SUBTOTAL IN EXCEL

The steps to do subtotal in Excel will be discussed with the help of an example.

Scenario:

Suppose we have a data which shows the number of vehicles sold in april and may and four days of week.

We’ll be totalling the number of vehicles sold in one month and subtotal it.

subtotal excel
SALES NUMBER ON WEEK DAYS

STEPS:

  • Select the data and click SUBTOTAL BUTTON.
  • The following screen will be shown.
SUBTOTAL DIALOG BOX EXCEL
SUBTOTAL DIALOG BOX
AT EACH CHANGE IN– Choose the value which will be base of your grouping.
USE FUNCTION: Choose the function
ADD SUBTOTAL TO: Choose the value which is to be added.

In our case we’ll be adding the vehicles sold. Fill the table and click OK.

SUBTOTAL EXCEL
SUBTOTAL BY VEHICLE NUMBER
OUTPUT:

It also groups the subtotals, which gives us the option of summarizing the tables easily. We can click the + sign and it’ll look like this.

RESULT SUBTOTAL EXAMPLE EXCEL
RESULT

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: