Formula Addition Copy
 

Example sheet 1
a1 to a1000 each has a different number:
sheet 2
cell a1 add sheet 1 a1 to a100
cell a2 add sheet 1 a101 to 200
Is there a way to copy formula into cell a3 without editing it.

Formula Addition Copy
 

one way:

Sheet2:
A1: =SUM(OFFSET(Sheet1!A$1,(ROW()-1)*100,0,100,1))

Copy down as necessary.

In article ,
Joey wrote:

Example sheet 1
a1 to a1000 each has a different number:
sheet 2
cell a1 add sheet 1 a1 to a100
cell a2 add sheet 1 a101 to 200
Is there a way to copy formula into cell a3 without editing it.

Formula Addition Copy
 

Put this in A2 and copy down:
=SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1))



Joey wrote:

Example sheet 1
a1 to a1000 each has a different number:
sheet 2
cell a1 add sheet 1 a1 to a100
cell a2 add sheet 1 a101 to 200
Is there a way to copy formula into cell a3 without editing it.

--

Dave Peterson

Formula Addition Copy
 

Hi, Thanks for help, however, i did not clearly post my problem
going to cell a3 sheet 2 need to copy formula making it additional 100 rows
201 to 300 can this be done
Thanks
Joe

"Dave Peterson" wrote:

Put this in A2 and copy down:
=SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1))



Joey wrote:

Example sheet 1
a1 to a1000 each has a different number:
sheet 2
cell a1 add sheet 1 a1 to a100
cell a2 add sheet 1 a101 to 200
Is there a way to copy formula into cell a3 without editing it.

--

Dave Peterson

Formula Addition Copy
 

I had a typo:

Put this in A1 and copy down:
=SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1))

But try it, then post back with your results.

Joey wrote:

Hi, Thanks for help, however, i did not clearly post my problem
going to cell a3 sheet 2 need to copy formula making it additional 100 rows
201 to 300 can this be done
Thanks
Joe

"Dave Peterson" wrote:

Put this in A2 and copy down:
=SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1))



Joey wrote:

Example sheet 1
a1 to a1000 each has a different number:
sheet 2
cell a1 add sheet 1 a1 to a100
cell a2 add sheet 1 a101 to 200
Is there a way to copy formula into cell a3 without editing it.

--

Dave Peterson


--

Dave Peterson

Formula Addition Copy
 

Ps. The typo was "put this in A2". It should be A1. The formula didn't
change.

Dave Peterson wrote:

I had a typo:

Put this in A1 and copy down:
=SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1))

But try it, then post back with your results.

Joey wrote:

Hi, Thanks for help, however, i did not clearly post my problem
going to cell a3 sheet 2 need to copy formula making it additional 100 rows
201 to 300 can this be done
Thanks
Joe

"Dave Peterson" wrote:

Put this in A2 and copy down:
=SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1))



Joey wrote:

Example sheet 1
a1 to a1000 each has a different number:
sheet 2
cell a1 add sheet 1 a1 to a100
cell a2 add sheet 1 a101 to 200
Is there a way to copy formula into cell a3 without editing it.

--

Dave Peterson


--

Dave Peterson

--

Dave Peterson

Formula Addition Copy
 

HI , Thank you. This is exactly what was needed.
Joe

"Dave Peterson" wrote:

Ps. The typo was "put this in A2". It should be A1. The formula didn't
change.

Dave Peterson wrote:

I had a typo:

Put this in A1 and copy down:
=SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1))

But try it, then post back with your results.

Joey wrote:

Hi, Thanks for help, however, i did not clearly post my problem
going to cell a3 sheet 2 need to copy formula making it additional 100 rows
201 to 300 can this be done
Thanks
Joe

"Dave Peterson" wrote:

Put this in A2 and copy down:
=SUM(OFFSET(Sheet1!$A$1,100*(ROW()-1),0,100,1))



Joey wrote:

Example sheet 1
a1 to a1000 each has a different number:
sheet 2
cell a1 add sheet 1 a1 to a100
cell a2 add sheet 1 a101 to 200
Is there a way to copy formula into cell a3 without editing it.

--

Dave Peterson


--

Dave Peterson

--

Dave Peterson