Xiao Yang Sum function with an example to explain the conditions detailed usage excel SumIF

Welcome to Office College, xiaoyang visit here waiting for you!

Today, we continue to learn together with you in all commonly used Excel spreadsheet formulas (functions) of the detailed usage and master the formula, many of our work will greatly improve the efficiency, we must learn yo, there do not understand can go to the Office College Questions (ask.officexy.com) here to ask Oh, we have progress, I will be pleased got:)

This lecture, we learn about the conditions sum function SumIF

Features
Under the conditions specified sum on a number of cells.

Syntax
SUMIF (range, criteria, sum_range)
Range is the range of cells for the conditional.
Criteria for determining which cells will be added to the sum of the conditions, the form of a number, expression, or text. For example, the condition can be expressed as 32, "32", "> 32", "apples".
Sum_range sum of the actual need of the cell. Only when the corresponding cell in Range to meet the conditions, the fishes in the cell sum_range sum. If you omit sum_range. Directly on the Range in the sum of the cell.

Help
Microsoft Excel also provides a number of other functions, they can analyze data based on a condition. For example, if you want to calculate a range of cells, text strings or numbers within the number of occurrences, you can use the COUNTIF function. If you want the formula to return two values under a condition of a certain value (for example, sales bonuses based on the specified sales return), you can use the IF worksheet function

Example 1

 B C D
1 Product Name Price (unit: yuan) of total sales commission
2 A 11 100
3 B 100 10
4 C 200 30
5 D 20 40
6 E 45 50
7 F 88 80
8
9 products price is greater than 50 the total sales commission 120 = SUMIF (C3: C8, "> 50", D3: D8)


Example 2
 B C D
Math 13 gender language
Male 45 68 14
Female 91 81 15
Male 80 70 16
Male 65 87 17
18 M 7279
Female 77 87 19
20
The language scores of 21 boys total 304 = SUMIF (B14: B19, "Male", D14: D19)

            The "male" and "women" because it is text-based, needs to be placed under the English double quotes ("man" and "female") in