It is possible that when performing mathematical operations such as addition, subtraction or multiplication we will not have problems. But when this process has to be done many times our work can get very tedious.
To make our life easier, Excel offers the possibility to insert formulas that allow us to perform these calculations in a few seconds.
An example of this can be found, when doing accounting and we have to include numerical values and do mathematical calculations. Even those who are dedicated to the trade or students use this tool to make automatic calculations. So let's see how to add by categories in excel.
How to add by categories in Excel
In this article we will show you how very simple 3 ways or ways to do this without getting too complicated. Just remember that you need to have your own table with all the data you want to add.
For example, let's take a table that contains suppliers in one column, another with products, another with quantity, price and subtotals.
How to add by categories in Excel - it's that easy" src="/images/posts/754c659739d4f0c778723b30096f2614-0.jpg">
As we will do a sum by categories, we will also position the totals we receive for each supplier. Suppose we receive from Sony, Samsung and LG, we want to know how much we receive for each product these electronics companies supply us.
Once our table is ready and with the data provided, we will sum up all the products that each supplier of electronic equipment supplies us, and for this we will proceed with three different modes:
First method to add by categories
The first thing we will do in this part is, for example, select under the Sony cell, so that the income that was generated is reflected there. And we enter the data manually, we write = SUMAR IF at this point a window will open indicating the data to be entered.
So it asks you to enter the range, let's keep writing = SUMARIF (B4: B47 these cells contain the providers. Let's continue with the criteria = SUMARIF (B4: B47; ”= SONY” this is to search, only the data which is contained in Sony Now we continue to enter the data and it follows the range, the sum.
Let's continue = SUMARIF (B4: B47; ”= SONY”; F4: F47) these cells would represent the subtotals, so hit the Enter key. If you enter the data correctly, the number should appear in that cell which will be the total income you received from the Sony provider. And you've already made one sum by categories using Excel.
Second method to add by categories
This method is very similar to the previous one, but differs in that you will select with the mouse without having to write the data. To start, go to the cell below Samsung, select and place the equal sum sign, = SUM it will appear automatically. Yes, you select it by double clicking.
Then go to the supplier column and select with the mouse pointer the first cell in our example would be B4. Press and hold on that cell and move to the last cell, that is B47.
At the top, the cells you have chosen appear marked. So put ;”= SAMSUNG”; and finally I select the subtotal cells with the mouse and press enter.
How to add by categories in Excel - it's that easy" src="/images/posts/754c659739d4f0c778723b30096f2614-1.jpg">
Third method to add by category
In the latter method, you just have to go to the fx function, create a clip and a small window will appear with the name search for a function. You have to place Add.si, the function will appear and you will make a clip on it. Another box appears showing Interval, you select a small box on the right side and create a clip.
It will take you to your table and you will need to indicate the supplier cells, i.e. B4 to B47. You come back and now select the criteria and enter “= LG”. And finally, Range_ sum go to the box next to it, select all the subtotal cells, make a clip and accept.
