Excel tip: How to use the SUMIF function

SUMIF function syntax is: SUMIF (range,criteria,sum_range)

The parameters for the SUMIF function are as follows:

The first parameter: range is the condition range, the range of cells used for the conditional judgment.

The second parameter: criteria is the summation condition, by the numeral, the logical expression and so on constituent's judgment condition.

Third parameter: Sum_range is the actual sum region, the cell, range, or reference that needs to be summed.

When the third argument is omitted, the conditional range is the actual summation area.

Wildcard characters are used in the criteria argument, including question marks (?) and asterisks (*). The question mark matches any single character, and the asterisk matches any string of characters. If you want to find the actual question mark or asterisk, type the tilde (~) before the character.

An introduction to the example of Excel SUMIF function

Example: To find the total flow of each column in the report

The results are shown in the following figure.

Select the F2 cell, enter the formula: =SUMIF (B2:B19,E2,C2:C19), after the formula is complete, press the keyboard Ctrl+shift+enter key combination (you must press this Ctrl+shift+enter key array formula to get the correct result), You can count the total flow of Office software column.

And so on, select F3 cell, input formula: =SUMIF (B2:B19,E3,C2:C19), input formula completed, press the keyboard Ctrl+shift+enter key combination, you can get the total flow of the website Operation column.

Select F4 cell, input formula: =SUMIF (B2:B19,E4,C2:C19), input formula completed, press the keyboard Ctrl+shift+enter key combination, you can get the total flow of computer Hospital column.

Select F5 cell, input formula: =SUMIF (B2:B19,E5,C2:C19), input formula completed, press the keyboard Ctrl+shift+enter key combination, you can obtain the total flow of tool software column.

Select the F6 cell, enter the formula: =SUMIF (B2:B19,E6,C2:C19), the input formula is completed, press the keyboard Ctrl+shift+enter key combination, you can obtain.