abc MICROSOFT EXCEL 2010 - Functions
Function SUMIF

Members of the first and the second team won points according to the table. Calculate how many points each team has won.


 

 

A

B

C

D

1

 Pero Team 1 5  

2

 Mika Team 2 4  

3

 Laza Team 1 3  

4

 Dule Team 2 2  

5

 Bane Team 2 2  

6

 Rale Team 1 1  

7

        

8

     Team 1 =SUMIF(B2:B7;C8;C2:C7)

9

     Team 2 =SUMIF(B2:B7;C9;C2:C7)

 

Picture 1. Results of the Sum If /FUNCTION SUMIF/

Picture 2. Sum if /FUNCTION SUMIF/

 

Function SUMIF, steps:

  1. Select an empty cell D9 (Team 1).
  2. Type =SUMIF.
  3. Define the area.
  4. Select the desired value (Team 1)..
  5. Select the range /RANGE/ of values (in this case POINTS).
  6. Enter button (ending the work on the formula) .
  7. Select an empty cell D10 (Team 2).
  8. Type =SUMIF.
  9. Define the area.
  10. Select the desired value (Team 2).
  11. Select the range /RANGE/ of values (in this case POINTS).
  12. Enter button (ending the work on the formula) .
  13. The end (Kraj).

 
Primjeri:    Primjeri: Funkcije SUMIF 141

Funkcije /Functions/    Index