Ask Your Question

How do I total a currency column in Calc [closed]

asked 2013-11-03 00:11:52 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

My bank provides the ability to download my monthly credit card statements in CSV format. I load these into Calc and categorize my expenses for taxes and budget comparison. I'm using Calc 4.1.x and win 8.1. I'm using a function such as =sum(a1:a20). The usual total result is the value in a1 or some random number or zero.

In addition I cannot get negative numbers to display in red. The are preceded by a minus sign.

Suggestions or other help will be appreciated.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-12 16:07:23.755825

2 Answers

Sort by » oldest newest most voted

answered 2013-11-03 02:59:58 +0200

m.a.riosv gravatar image

Hi moonvine, I think you need to set up properly in the import csv window, to get the right values in the sheet (clik in columns header). Seems you are getting dates and numbers as text.

To see negative numbers in red, change default cell style, F11 (Menu/Format/Styles&Formatting), right-click on Default style, select Numbers tab, where you can choose the format you like.

edit flag offensive delete link more


Mariosv, thanks for your help. Using your suggestion I was able to work through my problem

moonvine gravatar imagemoonvine ( 2013-11-03 19:07:11 +0200 )edit

answered 2013-11-03 02:34:43 +0200

Edward gravatar image

updated 2013-11-03 02:36:22 +0200

The random number or zero result may be due to the cell contents formatted as text. Try formatting as Number or Currency (which will also give you the option to display negative numbers in red)

edit flag offensive delete link more


Edward, thanks for your help. Using your suggestion I was able to work through my problem.

moonvine gravatar imagemoonvine ( 2013-11-03 19:06:33 +0200 )edit

Question Tools

1 follower


Asked: 2013-11-03 00:11:52 +0200

Seen: 4,661 times

Last updated: Nov 03 '13