Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
not summing all the cells
I wanted to sum the values from an column but for some cells it doesnt sum it
to the total. Why is this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
not summing all the cells
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 "Alina Roumania" wrote: I wanted to sum the values from an column but for some cells it doesnt sum it to the total. Why is this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
not summing all the cells
Format the Column as any number format (not text).
Copy any empty cell and select your Column again. PasteSpecial-Value-Add OK. -- Regards Dave Hawley www.ozgrid.com "Alina Roumania" <Alina wrote in message ... I wanted to sum the values from an column but for some cells it doesnt sum it to the total. Why is this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing every 7 cells consecutively | Excel Worksheet Functions | |||
Summing Cells with #N/A | Excel Worksheet Functions | |||
Summing of Two cells does not sum!! | Excel Discussion (Misc queries) | |||
summing cells with variables | Excel Discussion (Misc queries) | |||
Summing some cells | Excel Worksheet Functions |