Thread: Excel Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Excel Formula

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


"Renee Nguy" wrote:

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