View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KMG KMG is offline
external usenet poster
 
Posts: 5
Default 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.