abc MICROSOFT EXCEL 2010 - Functions
Function SUMIF - absolute values

Members of Teams 1 and 2 won points according to the table. Calculate how many points each Team won.
 


 

 

A

B

C

D

E

F

G

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($B$2:$B$7;C9;$C$2:$C$7)      

9

    Team 2 =SUMIF($B$2:$B$7;C10;$C$2:$C$7)      

10

             

 

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

Picture 2. sum if /FUNCTION SUMIF/

 

Function SUMIF - absolute values, steps:

  1. Select an empty cell D9 (Team 1).
  2. Type =SUMIF.
  3. Define the area.
  4. Absolute adressing the range ($) is done by pressing the functional button
  5. Select the desired value (Team 1).
  6. Select the range /RANGE/ of values (in this case POINTS).
  7. Enter button (ending the work on the formula) .
  8. Use the fill marker for remaining values.
  9. The end (Kraj).

 

Functions /Functions/    Index