2dumb4this wrote:keme wrote:To tell Calc that you want a calculation, you start the cell entry with an equals sign. So if your data are in column B, in cell B5 you would enter =B2-(B3+B4).

HUH? These are rows.......

- Code: Select all Expand viewCollapse view
`A B C D E`

MIKE $20 $10 $5 I want this row to = B-(C+D)

john $15 $8 $1 again want total

and on and on and on

Also where am i supposed to enter the formula you posted?

OK, there's a clash in terminology here. Sorry!

In everyday language, a "row" could mean any set of objects arranged along a straight line.

In spreadsheet terms, we have a grid, that divides the sheet up into cells. Cells along a horizontal line, normally labeled with a number at left, constitute a row. Cells along a vertical line, often labeled by a letter (or letter combination) at the top, constitute a column. That's why I misunderstood your description of rows. I was bound by the terminology, whereas your setup is of course the logical (and most common) one.

If you start in row 2 (using row 1 for headings), then you enter this formula in cell E2:

=B2-(C2+D2)Copy that formula to the next cell in column E, and you'll see that the row numbers of the cell references update accordingly.

OOo 3.3.0 and Apache OOo 3.4.1/4.0.0, on Ms Windows 7 and Mac OS-X.