Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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?

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.