Faced with a huge amount of data, your boss asks you to quickly sort it out and summarize last month’s sales volume in the next meeting? In order to improve work efficiency and save time, everyone in the workplace must learn Excel’s SUM, SUMIF, and SUMIFS, so that you can complete your work quickly and without errors! If you don’t know how to do it, come and take a look. We will teach you step by step!
1 – SUM
Companies you may be interested in
This is a must-know function for everyone. It can be said that we have already mastered this skill when we first learned to use Excel. With the help of the SUM function, when we need to count a large amount of data, we don’t have to waste time entering the computer one by one to calculate the total. Through Excel, we can complete the calculation with one click, ensuring zero errors and avoiding human errors.
The SUM function requires the input of Number 1, Number 2, ….
You can choose to enter the number Finland Phone Number List you want to calculate.
Or enter the area you want to sum.
In order to calculate quickly, it is usually entered directly into the sum area, for example: =SUM(D3:D11), and it’s done!
2 – SUMIF
When we have a large amount of data, but only want to calculate the total amount that meets the specified conditions, we will use SUMIF. For Israel Phone Number List example, when we sell products A, B, and C, but only want to calculate the total sales of product A, that is, we need to meet one condition. Of course, we will not use SUM to slowly enter the summation area, but choose SUMIF.
The SUMIF function window is as follows:
Range: The range where the condition is (in the above example, it is the product column)
Criteria: The condition (in the above example, it is product A)
Sum_range: The sum range (in the above example, it is the sales column)
In this way, you can calculate the total sales volume of product A with one click!
