In Excel, sumifs can sum cells with multiple conditions.
1. As shown in the figure below, A2 to A7 are departments, and B2 to B7 are the corresponding salary amounts.
2. Do we want to calculate the synthesis of a certain department? How do I use sumifs?
If we write: =sumifs(b2:b7, a2:a7,"Sales Department"As shown in the figure below, the number 11000 will be returned after entering.
3. Or use the above chestnut to apply this formula, =sumifs(b2:b7, a2:a7,"Customer Service Department"
4. After entering, you will get 10000.
Let's explain the formula:
This formula will calculate the sum of wages in the range B2:B7, which corresponds to the sum of all cells in the range A2:A7 with the median value of "Customer Service".
sumFunctions:
sumFunctions are the most basic summation functions in Excel. If you want to sum the numbers in a column or row, you can use this function. For example, if you use =sum(b2:b3), in Excel as shown below, the sum of b2 and b3 is 11000.
sumifs function:
The main difference between the sum function and the sumifs function is whether certain conditions need to be met.
The sumifs function is used to sum multiple conditions. You can use this function when you need to sum data based on one or more criteria.
The computer used in the above demonstration is Lenovo Legion R9000K, and the operating system is Windows 10, and the software version is Microsoft Excel 20212108, which is universal in actual use.
Excel column header 1234 how to convert back to abcd
How does the if function in excel determine the size of the number and whether it meets the conditions?