Share via

Auto Sum Function Not Totalling Columns

Anonymous
2012-01-31T15:35:56+00:00

I am trying to use autosum to total a column.  I have tried everything posted here but still no success,  I just get the following:  =sum(B3;B33).  My cell is set at general.  My calculation option is set at automatic.  What am I doing wrong?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2012-01-31T18:04:33+00:00

RAH wrote:

I am trying to use autosum to total a column.  I have tried everything posted here but still no success,  I just get the following:  =sum(B3;B33).  My cell is set at general.  My calculation option is set at automatic.  What am I doing wrong?

If this is happening in just one cell with formulas, it is probably because the cell was formatted as Text at the time that you entered the formula.  In that case, simply changing the format to General or any other numeric format afterwards is not sufficient.  You also need to "edit" the cell by pressing F2, then Enter.

Was this answer helpful?

2 people found this answer helpful.
0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2012-01-31T15:54:05+00:00

Do you mean that you see the formula in the cell instead of the result of the formula? If so, press Ctrl+` to toggle formula display off, or activate the Formulas tab of the ribbon and click to unhighlight the Show Formulas button.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest