Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
the simplest way is to use theC1 equation you have
in C2 use =c1+B2 and copy down. "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
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 "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
Thank you BJ. You're a genius!
"bj" wrote: the simplest way is to use theC1 equation you have in C2 use =c1+B2 and copy down. "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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
Thanks so much.
"Ron Coderre" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
Thanks so much Elkar.
"Elkar" wrote: 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 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) |