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

# 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.

## 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.

STEPS:

• Select the data and click SUBTOTAL BUTTON.
• The following screen will be shown.

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