Excel Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is what I currently have:
C1=A1+B1
C2=A1+B1+B2
C3=A1+B1+B2+B3
Please help me create a formula so I can drag down column C and it will pick
up B4 and B5 and B6 and so on.
Thank you so much.
Renee
 
How about this:

C1: ==SUM($A$1,$B$1:B1)
Copy C1 down as far as needed.

Note the dollar signs in the references.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
I think you're making this more complicated than it needs to be. Try this:

C1=A1+B1
C2=C1+B2

From this point, you should be able to copy C2 down and get your desired
results.

HTH,
Elkar
 
Thanks so much.

Ron Coderre said:
How about this:

C1: ==SUM($A$1,$B$1:B1)
Copy C1 down as far as needed.

Note the dollar signs in the references.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
Click to expand...
 
Thanks so much Elkar.

Elkar said:
I think you're making this more complicated than it needs to be. Try this:

C1=A1+B1
C2=C1+B2

From this point, you should be able to copy C2 down and get your desired
results.

HTH,
Elkar
Click to expand...
 
Back
Top