The difference between sumif and countif

1, sumif: use? SUMIF？ Function can sum the values within the report range that meet the specified conditions.

2.countif: Find the range and how many values meet the "what" condition and use it for counting.

Second, the grammar is different.

1, sumif:SUMIF (conditional region, condition and region).

2.countif:COUNTIF (order area, counting condition).

Third, the characteristics are different.

1. wildcard (including question mark (? ) and an asterisk (*). The question mark matches any single character; The asterisk matches any string. If you want to find the actual question mark or asterisk, type a tilde (~) before the character.

2.Countif: Countif (range, criteria), the parameter range is the range for which the number of non-empty cells is to be calculated, and the parameter criteria defines the conditions in the form of numbers, expressions or texts.

Baidu encyclopedia -countif

Baidu encyclopedia -sumif