Text and Sum

J

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
 
J

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
 
P

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
 
Top