Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
a simple 'sum' formula is not adding all of the data in range
a simple sum formula does not appear to be recognizing all of the numbers in
the range as numbers, and, therefore is not adding them to the total. I have tried formatting the column to 'number' but that doesn't help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
a simple 'sum' formula is not adding all of the data in range
Copy a blank cell.
Select the number range Right clickPasteSpecialselect Add Click OK.. Now check whether your formula is working If this post helps click Yes --------------- Jacob Skaria "Wild Cherry" wrote: a simple sum formula does not appear to be recognizing all of the numbers in the range as numbers, and, therefore is not adding them to the total. I have tried formatting the column to 'number' but that doesn't help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
a simple 'sum' formula is not adding all of the data in range
Hi,
If you see green triangles at the top left of some of the cells, select all the cell, put you mouse over one of the cells with a green triangle, to the left you will see a small yellow diamond icon, click it and choose Convert to Number. Once numbers have been entered as text formatting them will not change their data type. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Wild Cherry" wrote: a simple sum formula does not appear to be recognizing all of the numbers in the range as numbers, and, therefore is not adding them to the total. I have tried formatting the column to 'number' but that doesn't help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'SUM' isn't working - what would cause this ? | Excel Worksheet Functions | |||
creating a simple formula for a range of cells | Excel Discussion (Misc queries) | |||
how to put 'SUM' formula in VB after picking up certain names and their bonus | Excel Discussion (Misc queries) | |||
Why does a simple frequency distribution count out of range data? | Excel Worksheet Functions | |||
'SUM' Tables | Excel Worksheet Functions |