Posts by mcfingrs

    Re: Change sum range depending on today's date


    Resurrecting this thread for some similar help. Will someone illustrate OFFSET with this example so that I can try and adapt it to my workbook?


    Given the following:


    [TABLE="width: 801"]

    [tr]


    [td]

    CapEx

    [/td]


    [td]

    Apr-2014

    [/td]


    [td]

    May-2014

    [/td]


    [td]

    Jun-2014

    [/td]


    [td]

    Jul-2014

    [/td]


    [td]

    Aug-2014

    [/td]


    [td]

    Sep-2014

    [/td]


    [td]

    Oct-2014

    [/td]


    [td]

    Nov-2014

    [/td]


    [/tr]


    [tr]


    [td]

    Cap

    [/td]


    [td]

    35.69

    [/td]


    [td]

    37.49

    [/td]


    [td]

    35.07

    [/td]


    [td]

    -

    [/td]


    [td]

    -

    [/td]


    [td]

    -

    [/td]


    [td]

    -

    [/td]


    [td]

    -

    [/td]


    [/tr]


    [tr]


    [td]

    Exp

    [/td]


    [td]

    -

    [/td]


    [td]

    33.23

    [/td]


    [td]

    32.62

    [/td]


    [td]

    33.71

    [/td]


    [td]

    8.70

    [/td]


    [td]

    -

    [/td]


    [td]

    -

    [/td]


    [td]

    -

    [/td]


    [/tr]


    [tr]


    [td]

    Cap

    [/td]


    [td]

    -

    [/td]


    [td]

    -

    [/td]


    [td]

    22.87

    [/td]


    [td]

    23.84

    [/td]


    [td]

    23.84

    [/td]


    [td]

    23.08

    [/td]


    [td]

    14.61

    [/td]


    [td]

    -

    [/td]


    [/tr]


    [tr]


    [td]

    Cap

    [/td]


    [td]

    -

    [/td]


    [td]

    -

    [/td]


    [td]

    -

    [/td]


    [td]

    33.23

    [/td]


    [td]

    33.71

    [/td]


    [td]

    32.62

    [/td]


    [td]

    8.70

    [/td]


    [td]

    -

    [/td]


    [/tr]


    [tr]


    [td]

    Exp

    [/td]


    [td]

    -

    [/td]


    [td]

    -

    [/td]


    [td]

    -

    [/td]


    [td]

    -

    [/td]


    [td]

    30.69

    [/td]


    [td]

    30.13

    [/td]


    [td]

    31.14

    [/td]


    [td]

    8.04

    [/td]


    [/tr]


    [/TABLE]


    Based on today's date, I need to sum past amounts and current/future amounts, broken down by capital & expense.forum.ozgrid.com/index.php?attachment/57598/