Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    Offsetexample

    Uploaded by

    ivane iosebashvili

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Offsetexample

    Uploaded by

    ivane iosebashvili
    8 views1 page

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    8 views1 page

    Offsetexample

    Uploaded by

    ivane iosebashvili

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 1

    A B C D E F G H I J K

    1
    2
    3 Offset examples
    4
    5
    6 1 2 3 4 1 2 3 4
    7 5 6 7 8 5 6 7 8
    8 9 10 11 12 9 10 11 12
    9
    10 =SUM(OFFSET(B7,-1,1,2,1)) 8 =SUM(OFFSET(H6,0,1,3,2)) 39
    11
    12
    13
    14 1 2 3 4
    15 5 6 7 8
    16 9 10 11 12
    17
    18 =SUM(OFFSET(E16,-2,-3,2,3)) 24

    You might also like