Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Result of SUM is #
I have a spreadsheet where the result of using autosum is displayed as a
single #. Some of the cells being summed contain a 'x' but even if I chnage all these to numerics I still end up with #. I've tried reformatting the cells. This autosum is of 26 contiguos cells in a row. Funny thing is autosumming the same data down a column is OK. Any ideas folks?! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to .. | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel |