# 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.

1. Click the EDIT POST in the gray band immediately below your post