adding numbers

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

Hi,

This should be very simple and I have done it numerous
times, but I cant get it to give me the correct amount. I
have a header row so my formula is SUM(H2:H353) with the
toal in cell H354. Simple right? It should be But I know
for sure the number it is producing is wrong. I dont have
any subtotal formatting or any thing on the column, but
just in case removed any. What could this be?
 
Hi
maybe some values formated as 'Text'. You may put the following formula
in I2:
=ISNUMBER(H2)
and copy this down. It should return TRUE for all rows
 
Thanks Frank, however, when I changed column H from
the 'general' format to the 'number format', the only ones
that camr up TRUE where the numbers that had 2 decimal
places. Its like it didnt change all cells even though I
checked and it said they were in the number format.
 
Hi
this sounds like your other values are stored as 'Text'. Only changing
the format won't help. Try the following:
- select an empty cell and copy this cell
- select your data in column H
- goto 'Edit - Paste Special' and choose 'Add'

Now all rows should return 'TRUE' and the SUM formula should work
 
Thanks alot, it worked! Is there a problem if some of my
other columns have data that is text? Will it cause other
problems later on?
 
Back
Top