Sum groups of data in same column

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I have a question concerning a request that has been made of me. I
haven't been able to think of anyway to accomplish this using Excel's
formulas. Before I started trying to write a function to do this I
though I'd ask if anyone has a solution using Excel formulas.

I have been ask to sum groups of number down a single column that are
concurrent values other than zero. The data is batch production runs
over a month and would look as shown below. There would never be more
than three seperate runs per month. The formula would return a total
of 400 for the first run and 500 for the second run based on the
example. Any ideas or a positive it can't be done is ok, save me some
time trying.
Thanks

In Column "A"
0
0
0
100
100
100
100
0
0
0
0
0
100
100
100
100
100
0
0
 
Just re-read your post. I set up my formula to just look
for "100", but obviously a production run could be any
number other than 100 (except 0), so change "=100"
everywhere in the formula to "<>0". Sorry about that.

Jason
 
Jason, I'll start working with your example today. Thanks for pointing
me in the right direction.
Gary
 
Back
Top