Excel tip: How to use the SUMIF function

Source: Internet
Author: User
Tags 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.

Related Keywords:

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

• Sales Support

1 on 1 presale consultation

• After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

• Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.