Is it Series Summation?

[Mike]

Hi,

Say I have this:

A B
1 1
1 2
3 5
2 7
4 11.....and so on

How can I produce column B (e.g., B5=A5+B1+B2+B3+B4)?

Thanks,
Mike

 

[Don Guillett Excel MVP]

Hi,

Say I have this:

A   B
1    1
1    2
3    5
2    7
4    11.....and so on

How can I produce column B (e.g., B5=A5+B1+B2+B3+B4)?

Thanks,
Mike

=SUM($a$1:a1)

copy down

 

[Rick Rothstein]

The values you gave in Column B do not match the formula you said you want
in Column B. The values you put in Column B are derived by adding the values
in Column A from A1 to the row you are on; in other words, this formula
placed in B1 and copied down...

=SUM(A$1:A1)

However, to implement the formula relationship you said you wanted
(B5=A5+B1+B2+B3+B4), you would have to use these formulas in the indicated
cells...

B1: =A1
B2: =A2+SUM(B$1:B1)

and copy the formula in B2 down. When you do this, the formula relationship
you said you wanted would have produced the following data instead of what
you posted...

A B
1 1
1 2
3 6
2 11
4 24

So, which did you really want?

Rick Rothstein (MVP - Excel)




"Mike" wrote in message

Hi,

Say I have this:

A B
1 1
1 2
3 5
2 7
4 11.....and so on

How can I produce column B (e.g., B5=A5+B1+B2+B3+B4)?

Thanks,
Mike