sum based on series of repeating values

  • Help!!!!!!


    I have an excel sheet such as
    a........b.........c.........d............e................f.....................g
    date Ladle Input sl Saftey Calculated sl Campaigns Calculated sl this Series
    1/1/11 31.....100......200.........100............1
    1/1/11 32
    1/1/11 33
    1/2/11 31.....150......300..........50............2
    1/2/11 32
    1/2/11 33
    1/3/11 31.....160......310..........10............3 ? ..........??? ans should be 160
    1/3/11 32
    1/4/11 31 .....1..........1.............1............1
    ETC......................................................
    When campain is set back to one. I would like to total the Calculated sl from campaign 3 back to campain 1 on ladle 31. Campaigns could go as high as 100... entire sheet is a named range 'steelladledatainput'. Any Thoughts? Please!

  • Re: sums based on criteria repeating value


    Hello mike,


    Welcome to Ozgrid.


    It will be best to upload a sample workbook (sensitive data scrubbed/removed) that shows a few manually created examples of the desired results.
    The structure and data types of the workbook must exactly match that of the real workbook. Include in the workbook a clear and explicit explanation of all requirements.
    The samples workbook only needs to contain enough data to illustrate the need to aid with developing the solution.


    [COLOR="navy"]How to edit your post or thread title or upload an attachment[/COLOR]


    1. Click the EDIT POST in the gray band immediately below your post
    2. Click Go Advanced
    3. Edit the post or thread title
    4. To upload: scroll down to Manage Attachments