Ask Your Question

Can't sum numbers?

asked 2017-08-23 03:40:13 +0200

tino gravatar image

I am currently reviewing a very large (like, over 4,000 rows, 30-some columns) dataset as part of an application process. I need to sum multiple columns together into a new column, to do this, I am using the formula =SUM(AF1,AG1,AH1,AI1,AJ1) and using the little box thing to extend it to the rest of the column. I know the the sum equation works because I have a row i filled w/ ones to test it, but unfortunately, each other row in that column is resulting in a zero. I already changed all the columns to get rid of the $ signs in front of them [using =RIGHT(K1, LEN(K1)-2)] but it's still not working. I have tried to format the numbers into numbers, but I'm not sure if I'm doing it right, because it's still not working. Most of the numbers have commas in them, all of them are followed by a decimal point and two zeros. How can i fix this so can sum these columns?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-08-23 03:55:44 +0200

robleyd gravatar image

Try View | Value Highlighting - or Ctrl-F8 (Win or Linux) - to see how the "numbers" are actually stored.,Text cells will be formatted in black, formulae in green, and number cells in blue, no matter how their display is formatted.

If they are stored as text, look into Data | Text to Columns as a possible solution. I'd suggest initially working with a copy of your file.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-23 03:40:13 +0200

Seen: 1,241 times

Last updated: Aug 23 '17