Ask Your Question

what is the formula to calculate a simple spreadsheet

asked 2019-02-20 13:17:54 +0200

Gill Spong gravatar image

updated 2019-02-20 15:54:13 +0200

I wish to do a simple spreadsheet but need the formula for calculating a total with debit and credit columns

edit retag flag offensive close merge delete


Changed tag to Calc

SM_Riga gravatar imageSM_Riga ( 2019-02-20 15:54:28 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-02-20 14:58:32 +0200

Opaque gravatar image

updated 2019-02-20 15:00:00 +0200

Hi maybe I get you completely wrong but "=SUM(<range>)" 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


to some other cell of your convenience to get the sum.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-20 13:17:54 +0200

Seen: 62 times

Last updated: Feb 20 '19