Ask Your Question

When I try to sum a column of dollar amounts, it returns 0. I use the sum function, highlight the column, and then hit enter. What am I doing wrong?

asked 2017-12-01 16:46:32 +0100

ppearce43 gravatar image

When I try to sum a column of dollar amounts, it returns 0. I have a column, let's say, consisting of $1.23, $2,87, and $5.55. I enter the sum function in the cell under $5.55, then click on the $5.55 cell, hold the shift key down, and then click on the $1.23 cell. Those cells are then outlined in red. Then I press Enter. The cell where the formula is now turns to the character "0" (without the quotes). I'm doing something wrong, of course, but as a newbie, I can't figure out what that is. Any help appreciated.

edit retag flag offensive close merge delete


The forumula I enter, as an example, is =sum(u395:u397)

ppearce43 gravatar imageppearce43 ( 2017-12-01 16:50:38 +0100 )edit

Have you added the dollar-signs yourself or are they generated because you specified the format to be a currency? If the format ain't specified as a currency, the sum-function won't work as it has to sum up text-strings. Please, check the format-option of the columns used

PèreOrval gravatar imagePèreOrval ( 2017-12-01 17:31:46 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-12-01 18:22:31 +0100

Jim K gravatar image

updated 2017-12-01 18:22:49 +0100

It seems the data is text rather than numeric.

Instead, format the cells for currency, as described at Then enter the values as a currency number.

A quick way to do this is Edit -> Find & Replace to remove all of the $. It may help to expand Options and uncheck Regular Expressions.

This question was also answered at

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-12-01 16:46:32 +0100

Seen: 7,536 times

Last updated: Dec 01 '17