abc MICROSOFT EXCEL 2010 - Functions
Function SUMIF - relational operator

EXCEL has the capability of choosing based on the relational operators. Viewed is adding up the larger (e.g. from 4) and smaller (e.g. from 6). 


 

 

A

B

C

D

1

 5      

2

 4      

3

 2      

4

 6      

5

 1      

6

 4      

7

 2   <6 =SUMIF($A$1:$A$10;C7;$A$1:$A$10)

8

 1   >4 =SUMIF($A$1:$A$10;C8;$A$1:$A$10)

9

 4      

10

 3      

 

Picture 1. Results by subject

Picture 2. sum if /FUNCTION SUMIF/

 

Function SUMIF - relational operator, steps:

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

 

Functions /Functions/    Index