|
|
Condition - Function SUMIF
Page visited 24762 times
|
1. This function is like COUNTIF but one more parameter
The function has 3 parameters : the range of cells where are the criteria, the criteria himself, the range of cells to add
|
|
|
|
|
|
|
|
|
2. For instance, you want to know the quantity of Pencil sold
|
|
|
|
|
|
|
|
|
3. Write the name of the function
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
4. Select the range of cells where are the criteria "Pencil"
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
5. Select the criteria.
Until now, there is no difference with the function COUNTIF
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
6. Last step, you select the range of cells where are located the data you want to add
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
7. The function is :
|
|
|
Formule de la cellule
=SUMIF (B3:B12;"Pencil";C3:C12) |
|
|
|
|
|
|
|
|
8. Now, if we want to calculate the amount of the Pencils' orders, we just have to change the 3rd parameter of the function et select the data of the column E
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
9. And so, you have the following result
|
|
|
Formule de la cellule
=SUMIF (B3:B12;"Pencil";E3:E12) |
|
|
|
|
|
|
|
|
