Summary of typical usage of Excel SUMIF function

This article brings you relevant knowledge about excel, which mainly introduces related issues about the SUMIF function. The SUMIF function is used to sum the values ​​that meet the conditions in the area. The following is Let's take a look, hope it helps everyone.

Related learning recommendations: excel tutorial

The SUMIF function is used to sum the values ​​that meet the conditions in a range. She has only 3 parameters:

=SUMIF (conditional area, specified condition, area to be summed)

If the summation area is omitted, the conditional area will be used as the summation area.

Is the SUMIF function really that simple? Today we will take a look at the typical usage of this function.

1. Return the total amount of Ruhua

=SUMIF(B:B,"Ruhua",C:C)

2. Return the total amount except Ruhua

=SUMIF(C:C,”>900″)

##3. Total amount greater than 900

=SUMIF(C:C,”>900″)

4. The total amount below the average

=SUMIF(C: C,"Note that when using other formulas as summation conditions, if the comparison operators greater than, less than, and not equal are used before the formula of the summation condition, , use half-width quotation marks before and after the operator, and use the connector & to connect the comparison operator to the formula.

5. Return the total amount of money whose name contains "花"

=SUMIF(B:B,"*花*",C:C)

6. Return the amount before the current date

=SUMIF(A:A,”

7. Ignore error value summation

=SUMIF(C:C,”The summation parameter is omitted, Taking the condition area C:C as the summation area, the summation condition is

8. Return the total amount of Ruhua and Qiuhua

=SUM(SUMIF(B:B,{"Ruhua","Qiuhua"}, C:C))

9. Sum of staggered columns

=SUMIF(B:H,K3,C:I)

Conditions and summation areas are misquoted.

If column B:H is equal to the name in cell K3, sum the values ​​in the same position in column C:I.

Related learning recommendations:

excel tutorial

The above is the detailed content of Summary of typical usage of Excel SUMIF function. For more information, please follow other related articles on the PHP Chinese website!