Text and Sum

[Jonsson]

Hi,

Is there a way to sum A1:A20, and having text in A10, without gettin
####.
I dont want to sum A1:A9;A11:A20
Maybe there is a way to format the cells in a special way?

//Thoma

 

[JulieD]

Hi

=SUM(A1:A20) works for me
#### generally means the column isn't wide enough ... just double click
between the A & B on the column headers to expand the width of column A

Cheers
JulieD

 

[Paul B]

Jonsson, =SUM(A1:A20) sum should not be affected by the text in A10
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003

 

[Guest]

Format the column as General and the sum formula should work.