View Single Post
  #1   Report Post  
TonyJag via OfficeKB.com
 
Posts: n/a
Default 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?!