Ask Your Question
0

what is the formula to calculate a simple spreadsheet

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

Gill Spong gravatar image

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

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

Comments

Changed tag to Calc

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

1 Answer

Sort by » oldest newest most voted
0

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

Opaque gravatar image

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

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

=SUM(A1:A30)

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

Stats

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

Seen: 53 times

Last updated: Feb 20