adding numbers

[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?

 

[Frank Kabel]

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

 

[Guest]

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.

 

[Frank Kabel]

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

 

[Guest]

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?

 

[Frank Kabel]

Hi
yes this could cause problems. I would assume you have imported this
data?