Very hard to advise without seeing the data
Want to send me a file -get my email from my website
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"kmg" wrote in message
...
I am working on a lengthy worksheet and have many link to one colmn from
other worksheets so that I can get the totals of all in the column. When I
put in the simple formula of =sum(B10:B2) the total comes up as 0. I
tried
setting the column to general, does not work, tried the copy a blank to
the
column with paste special an add, does not work. Do not know what next to
trouble shoot with.