I wish to do a simple spreadsheet but need the formula for calculating a total with debit and credit columns
Changed tag to Calc
Hi
maybe I get you completely wrong but “=SUM()” is the right function to sum up values in a column.
Example:
Assuming your values are in cells A1 through A30 (30 values) then write
=SUM(A1:A30)
to some other cell of your convenience to get the sum.