How to get the TOTAL and SUBTOTAL in EXCEL - Complete guide (example)

Who I am
Catherine Le Nevez

Author and references

In any office they will evaluate those employees who have knowledge of Excel. Especially if the job is to keep the accounts of the place or make repeated calculations of any kind. The more you deepen your knowledge of office automation, the greater the chances of being hired in the place you want.

How to get the TOTAL and SUBTOTAL in EXCEL - Complete guide

Well, currently, these techniques are essential to improve the efficiency of all automatable processes. For all of the above, today we will teach you how to get total and subtotal in excel , of many values, quickly.

It is a question of going step by step, advancing in the different instruments for the office of the Microsoft Office suite. You can, for example, set a goal to work with a different one every day. Create an itinerary with tutorials on how to use Word, PowerPoint and Excel.

Go at your own pace, you can always check the guides again. You don't need to feel pressured, the idea is that this is good for you.

Remember that there are two requirements to follow this tutorial. Know the basic use of some of the Office software. And, of course, you have purchased and downloaded Microsoft Excel from its official website.

The acquisition of this program will be a very worthwhile investment for your professional development, you will not regret it. Just make sure you are responsible for your schedule for good learning.

If you've made it this far, I guess you're ready to go. Remember to practice while reading the guide. Experimenting first person the process, you will assimilate it much faster. In addition, you will be able to re-read the passages that generate doubts at the moment. Don't be frustrated if something doesn't go as you expected at first.

Read How to Create LOSS OF EMPLOYEES in Excel (example)

What is Excel?

This software is the most used spreadsheet in the world. It is a type of document, in which you can work with numbers, functions and tables of all kinds. The sheet is divided into celle , arranged in rows and columns, distributed practically unlimited.

How to get total and subtotal in Excel?

The process is quite simple. What we need is have an Excel spreadsheet , in which we have previously entered the numerical data of the value of different goods or services. Be it for shopping, shopping or other things.

Since both the total and the subtotal are values ​​that we want to add; we will use the SUM function . To do this, we will go to a cell a little different from the ones that have the digits to add and we will type: =SUM()

Between the brackets of the previous formula, we will need to cover all the cells to be added. For example, if you are invoicing for the sale of 20 products and you have their prices in cells A, you should enter: =SUM(A2:A21)

Next to that first sum, where we will cover the values ​​of 20 products (from cell A2 to A21 in this example, which will vary depending on your table), we will write SUBTOTAL .

La difference between the total and the subtotal is that the first also includes tax charges and other additional costs, unrelated to the purchase as such. In this example, we will add a 16% tax to our subtotal.

automatically calculate the tax from the subtotal, we will write the name of the tax in one cell and, in the next cell, we will work with a formula. If it is 16%, a rule of three in the form is sufficient = (subtotal * 16) / 100 . Where we will replace the word subtotal, with the coordinates of the cell in which we are calculating it.

Read Solution: What to do when a game closes by itself when I open it on PC?

Finally, we will get the total , adding, in a separate cell, the subtotal and the tax. All you have to do is reuse the sum formula, but this time, enter the coordinates of the subtotal and tax cells, separated by a comma: = SUM (subtotal, taxes)

Remember you can customize cells or tables at your convenience, to make it easier to view an invoice.

add a comment of How to get the TOTAL and SUBTOTAL in EXCEL - Complete guide (example)
Comment sent successfully! We will review it in the next few hours.