summing back to a changing but 'set' #

[colin]

I tried this before but I think my questiopn was poorly
worded so I'll try again.

I have 2 columns 'A' and 'B'. Column A is numbered
sequentially from 1-26,53-80, 105-132, etc for 30 000
rows. Column 'B' has varying values. I would like to
get a running sum of column 'B' for values 1-26 in
column 'A' but I would like to start over and get a
running sum of column 'B' corresponding to 53-80 in
column 'B'.

So if I am at # 60 in column 'A' I will have a sum of the
values in 'B' from 53-60, for # 61 in column 'A' I will
have a sum of values in column 'B' for 53-61 but once I
get to 107 for example my sum will be from 105-107.

Thanks

 

[RagDyer]

I can't seem to find a pattern to your numbering of column A.

So, in C1 enter:
=B1

in C2, enter:
=IF(A1+1=A2,C1+B2,B2)

And drag down to copy as needed,
OR
If there are no empty cells in column B,
Simply *double click* the "fill handle" of C2, to automatically copy C2 as
far down column C as there is data in column B.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I tried this before but I think my questiopn was poorly
worded so I'll try again.

I have 2 columns 'A' and 'B'. Column A is numbered
sequentially from 1-26,53-80, 105-132, etc for 30 000
rows. Column 'B' has varying values. I would like to
get a running sum of column 'B' for values 1-26 in
column 'A' but I would like to start over and get a
running sum of column 'B' corresponding to 53-80 in
column 'B'.

So if I am at # 60 in column 'A' I will have a sum of the
values in 'B' from 53-60, for # 61 in column 'A' I will
have a sum of values in column 'B' for 53-61 but once I
get to 107 for example my sum will be from 105-107.

Thanks