For each row of data, I want to display the difference between the value in
cell C of the current row, and C in the next row. eg where "x" is the
current row:
=SUM (C(x+1), -Cx)

How do I create this formula ?

You can not use the value in the same cell containing the formula

You can have this in D3
=C3-C4 to get the difference, between C3 and C4, in D3

"jlk" wrote:

For each row of data, I want to display the difference between the value in
cell C of the current row, and C in the next row. eg where "x" is the
current row:
=SUM (C(x+1), -Cx)

How do I create this formula ?

Thank you, I do plan to use D3. However my sheet is hundreds of rows long. I
wish to enter one formula for the whole sheet, not in each row. How to do?


"Sheeloo" wrote:

You can not use the value in the same cell containing the formula

You can have this in D3
=C3-C4 to get the difference, between C3 and C4, in D3

"jlk" wrote:

For each row of data, I want to display the difference between the value in
cell C of the current row, and C in the next row. eg where "x" is the
current row:
=SUM (C(x+1), -Cx)

How do I create this formula ?

Enter the formula in D3
Select D3
Choose Edit-Copy
Select from D3 down to the last cell in Col D
Choose Edit-Paste

"jlk" wrote:

Thank you, I do plan to use D3. However my sheet is hundreds of rows long. I
wish to enter one formula for the whole sheet, not in each row. How to do?


"Sheeloo" wrote:

You can not use the value in the same cell containing the formula

You can have this in D3
=C3-C4 to get the difference, between C3 and C4, in D3

"jlk" wrote:

For each row of data, I want to display the difference between the value in
cell C of the current row, and C in the next row. eg where "x" is the
current row:
=SUM (C(x+1), -Cx)

How do I create this formula ?

Thank you!! (I thought there would be a simple solution)

"Sheeloo" wrote:

Enter the formula in D3
Select D3
Choose Edit-Copy
Select from D3 down to the last cell in Col D
Choose Edit-Paste

"jlk" wrote:

Thank you, I do plan to use D3. However my sheet is hundreds of rows long. I
wish to enter one formula for the whole sheet, not in each row. How to do?


"Sheeloo" wrote:

You can not use the value in the same cell containing the formula

You can have this in D3
=C3-C4 to get the difference, between C3 and C4, in D3

"jlk" wrote:

For each row of data, I want to display the difference between the value in
cell C of the current row, and C in the next row. eg where "x" is the
current row:
=SUM (C(x+1), -Cx)

How do I create this formula ?

Did you get what you wanted?

"jlk" wrote:

Thank you!! (I thought there would be a simple solution)

"Sheeloo" wrote:

Enter the formula in D3
Select D3
Choose Edit-Copy
Select from D3 down to the last cell in Col D
Choose Edit-Paste

"jlk" wrote:

Thank you, I do plan to use D3. However my sheet is hundreds of rows long. I
wish to enter one formula for the whole sheet, not in each row. How to do?


"Sheeloo" wrote:

You can not use the value in the same cell containing the formula

You can have this in D3
=C3-C4 to get the difference, between C3 and C4, in D3

"jlk" wrote:

For each row of data, I want to display the difference between the value in
cell C of the current row, and C in the next row. eg where "x" is the
current row:
=SUM (C(x+1), -Cx)

How do I create this formula ?

Or, having entered the formula in D3, double-click the fill handle in the
bottom right-hand corner of D3 and it will fill all the way down the length
of a continuous range in column C.
--
David Biddulph

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
Enter the formula in D3
Select D3
Choose Edit-Copy
Select from D3 down to the last cell in Col D
Choose Edit-Paste

"jlk" wrote:

Thank you, I do plan to use D3. However my sheet is hundreds of rows
long. I
wish to enter one formula for the whole sheet, not in each row. How to
do?


"Sheeloo" wrote:

You can not use the value in the same cell containing the formula

You can have this in D3
=C3-C4 to get the difference, between C3 and C4, in D3

"jlk" wrote:

For each row of data, I want to display the difference between the
value in
cell C of the current row, and C in the next row. eg where "x" is
the
current row:
=SUM (C(x+1), -Cx)

How do I create this formula ?

If your data begins in C1, just enter

=C2-C1

and then select all the cells down column D and then press CTRL R (or
choose Fill Down on the Edit menu) to fill the formula down all the
rows in the selected range. Excel will automatically change the row
numbers in the formula as it fills down. Of course, if your data
starts on a row other than 1, change the row numbers in the original
formula to those row numbers.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Sat, 13 Dec 2008 18:03:00 -0800, jlk
wrote:

For each row of data, I want to display the difference between the value in
cell C of the current row, and C in the next row. eg where "x" is the
current row:
=SUM (C(x+1), -Cx)

How do I create this formula ?