How to use the SUMIF function

time：2025-03-07 16:02:22 Smart Hardware

Usage of sumif

The SUMIF function is a common function in Excel that is used to sum several cells, regions, or references based on specified criteria. The syntax is: =SUMIF(range, criteria, sum_range). The parameters are as follows:

1. Range: Conditional area, the cell area used for conditional judgment.

2. Criteria: Summation conditions, which are determined by numbers, logical expressions, etc. You can use wildcards (question mark (?) and asterisks (*), question marks match any single character, and asterisks match any string of characters.

3. Sum_range: The actual summation area, the cell, region, or reference that needs to be summed. When the third parameter is omitted, the conditional region is the actual summation region.

For example, find the total traffic for each column in a report. Select cell F2, enter the formula: =SUMIF(B2:B19,E2,C2:C19), after entering the formula, press the enter key directly, and the total traffic of the office software column can be counted. And so on, you can find the total traffic of other columns.

# Smart Hardware #

《How to use the SUMIF function》 This does not represent the views of this website. If there is any infringement, please contact us to delete it.

Latest article

Recommend

Ranking