Kinda new at this so maybe I'm asking for the impossible:?

Question

Working with MS Works Spreadsheet...Need formula for adding all deposits (A3 to A7) then subtracting all expenses (C32). The balance should show in A32.

Answer 1

in A32 type the following =sum(A3:A7)-C32

Answer 2

Add this formula to field A32:

=SUM(A3:A7) - C32

Answer 3

If it works like Excel, you can do the following:

To add:
(in A8 we'll say)
=SUM(A3:A7)

Then Subtract:
=A8-C32

Answer 4

=SUM(A3:A7) write in A32 for answer to be there repeat process with all other

Answer 5

Column to subtotal

Subtotals

Make sure the data you want to subtotal is in list format: each column has a label in the first row and contains similar facts, and there are no blank rows or columns within the list.
Click a cell in the column to subtotal. you'd click a cell in the Sport column, column B.
Click Sort Ascending or Sort Descending .
On the Data menu, click Subtotals.
In the At each change in box, click the column to subtotal. In the example above, you'd click the Sport column.
In the Use function box, click the summary function you want to use to calculate the subtotals.
In the Add subtotal to box, select the check box for each column that contains values you want to subtotal. In the example above, you'd select the Sales column.
If you want an automatic page break after each subtotal, select the Page break between groups check box.
If you want the subtotals to appear above the subtotaled rows instead of below, clear the Summary below data check box.
Click OK.
Note You can use the Subtotals command again to add more subtotals with different summary functions. To avoid overwriting the existing subtotals, clear the Replace current subtotals check box.