Usage of conditional sum SUMIF in excel

Many people are using EXCEL to make various forms, but few will use the functions. At least few of us use them. In fact, you only use the EXCEL worksheet function 1%, today, we will talk about the usage of the SUMIF "conditional summation" function.

SUMIF is used in EXCEL to sum by conditions.

Syntax

SUMIF (range, criteria, sum_range)
1. range: condition area. Generally speaking, it is the area where conditions need to be determined.
2. criteria: condition, which can be equal to, greater than, or less than the value type.
3. sum_range: Sum area

Instance

Similar to the following table, how do we sum conditions?

Name	Weight
Apple	2
Bananas	1
Durian	3
Grape	5
Apple	6
Grape	7
Bananas	8
Durian	9

If we want to sum up Apple, durian, banana, and grape by fruit type
What should I do?
Use the SUMIF function.

As shown in the preceding figure,

Sum Apple, we want= SUMIF (A2: A9, "Apple", B2: B9)
Sum durian we want= SUMIF (A2: A9, "Durian", B2: B9)
Sum bananas, we want= SUMIF (A2: A9, "banana", B2: B9)
Sum grape, we want= SUMIF (A2: A9, "grape", B2: B9)

Summary
The preceding descriptions are equal to, greater than, or less than, which are used for the comparison of numeric types.
It is also very easy to use, as long as you use> (greater than the number), <(less than the number,
For the convenience of horizontal drag and vertical drag to copy the formula, you need to use the $ symbol in the lock horizontal and vertical,
In particular, the conditional summation of such fixed areas is particularly useful. This document should be sorted out later.