Please enable JavaScript.

Coggle requires JavaScript to display documents.

CALCULATIONS PART :TWO: (8:54 (MIN, MAX, AVERAGE), 8:55 COPYING FORMULA…

- - - - REFERENCES
        
        SMARTLY
- - - - F4
        
        HOTKEY
      - $
        
        CONSTANT
      - ROW
      - COLUMN
      - TYPE
        
        RELATIVE
        
        <====
        
        CHANGE
        
        WHEN
        
        COPY
        
        ABSOLUTE
        
        :red_cross:CHANGE
        
        WHEN
        
        COPIED
        
        $COL
        
        $ROW
        
        :fishing_pole_and_fish:
        
        $A$5
        
        MIXED
        
        CELL
        
        REFERENCE
        
        :fishing_pole_and_fish:
        
        B$1
        
        COPY
        
        1 more item...
- - - - LESSON
        
        AUTOFILL
        
        DRAG
        
        MOUSE
    - - CTRL V
        
        CELL
        
        REFERENCE
        
        SAME
        
        EFFECT
    - - CUT
        
        REFERENCE
        
        DON'T
        
        CHANGE
- - - - NUMBER
        
        CELLS
        
        CONTENT =
        
        NUMBER
        
        RANGE
    - - all CELLS
        
        :red_cross: EMPTY
    - - NUM
        
        EMPTY
        
        CELLS
        
        RANGE
    - - (range ,
        
        criteria )
        
        .
      - :fishing_pole_and_fish:
        
        EQUAL
        
        ZERO
        
        =COUNTIF(B2:NB2,0)
      - :fishing_pole_and_fish:
        
        BIGGER
        
        THAN
        
        :zero:
        
        =COUNTIF(B2:NB2, ">"&0 )
      - :fishing_pole_and_fish:
        
        TEXT
        
        CRITERIA
        
        =COUNTIF (A2:A9, "SPECIFIC STRING")
        
        EXACT
        
        MATCH