Cannot get the column to total with =sum
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.
|