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