software

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.
Reneethe simplest way is to use theC1 equation you have
in C2 use
=c1 B2
and copy down.
quot;Renee Nguyquot; wrote:

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

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-Proquot;Renee Nguyquot; wrote:

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

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
quot;Renee Nguyquot; wrote:

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

Thank you BJ. You're a genius!

quot;bjquot; wrote:

gt; the simplest way is to use theC1 equation you have
gt; in C2 use
gt; =c1 B2
gt; and copy down.
gt; quot;Renee Nguyquot; wrote:
gt;
gt; gt; This is what I currently have:
gt; gt; C1=A1 B1
gt; gt; C2=A1 B1 B2
gt; gt; C3=A1 B1 B2 B3
gt; gt; Please help me create a formula so I can drag down column C and it will pick
gt; gt; up B4 and B5 and B6 and so on.
gt; gt; Thank you so much.
gt; gt; Renee
gt; gt;

Thanks so much.

quot;Ron Coderrequot; wrote:

gt; How about this:
gt;
gt; C1: ==SUM($A$1,$B$1:B1)
gt; Copy C1 down as far as needed.
gt;
gt; Note the dollar signs in the references.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Renee Nguyquot; wrote:
gt;
gt; gt; This is what I currently have:
gt; gt; C1=A1 B1
gt; gt; C2=A1 B1 B2
gt; gt; C3=A1 B1 B2 B3
gt; gt; Please help me create a formula so I can drag down column C and it will pick
gt; gt; up B4 and B5 and B6 and so on.
gt; gt; Thank you so much.
gt; gt; Renee
gt; gt;

Thanks so much Elkar.

quot;Elkarquot; wrote:

gt; I think you're making this more complicated than it needs to be. Try this:
gt;
gt; C1=A1 B1
gt; C2=C1 B2
gt;
gt; From this point, you should be able to copy C2 down and get your desired
gt; results.
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt;
gt; quot;Renee Nguyquot; wrote:
gt;
gt; gt; This is what I currently have:
gt; gt; C1=A1 B1
gt; gt; C2=A1 B1 B2
gt; gt; C3=A1 B1 B2 B3
gt; gt; Please help me create a formula so I can drag down column C and it will pick
gt; gt; up B4 and B5 and B6 and so on.
gt; gt; Thank you so much.
gt; gt; Renee
gt; gt;