not summing all the cells

A

Alina Roumania

I wanted to sum the values from an column but for some cells it doesnt sum it
to the total. Why is this?
 
A

Andrea Jones

Maybe some of the numbers have been formatted as text, are any of them
left-aligned instead of right-aligned? To convert text cells to number
format you will need to highlight them and use Format->Cells to set the
format to number, then click on each cell and press F2 followed by Enter as a
bug in Excel means text cells won't convert immediately back to number unless
you re-enter the data.

Andrea Jones
www.stratatraining.co.uk
 
O

ozgrid.com

Format the Column as any number format (not text).
Copy any empty cell and select your Column again.
PasteSpecial-Value-Add OK.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting the Vertical SUM of a (Custom-Calculated) Duration Field?? 0
Multiple IF Statement in Word 5
Formatting question: how to format duration (time spent)? 0
formula for arriving net difference 0
Why cant I expand the equations parameters without error? 5
Cell not calculating after importing data 2
Need help with Excel Formula for calculating sum of products depending on criteria 3
Finding largest total of ANY two values in a data set 6

Top