Cannot get the column to total with =sum
in [Functions]
|
Prev: Conditionally format a cell using a list of data defined in a rang
Next: edit the cell contents command in Excel 2007 macro
From: kmg on 4 Mar 2010 12:49 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.
From: Bernard Liengme on 4 Mar 2010 13:08 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" <kmg(a)discussions.microsoft.com> wrote in message news:755EF622-D1D5-4381-AC1B-1CF4983F3D6A(a)microsoft.com... > 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.
From: Fred Smith on 4 Mar 2010 13:59 All the problems you've listed makes it look like your data is text, not numbers. What happens when you simple enter a number like 10 in, say, B3? Does your sum change to 10? If so, it means your range contains text, not numbers. That's what you have to fix. Regards, Fred "kmg" <kmg(a)discussions.microsoft.com> wrote in message news:755EF622-D1D5-4381-AC1B-1CF4983F3D6A(a)microsoft.com... >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.
From: kmg on 4 Mar 2010 14:16 I have sent you a sample of the file. "Bernard Liengme" wrote: > 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" <kmg(a)discussions.microsoft.com> wrote in message > news:755EF622-D1D5-4381-AC1B-1CF4983F3D6A(a)microsoft.com... > > 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. > > . >
From: kmg on 4 Mar 2010 14:48
Just tried that and it does now work. "Fred Smith" wrote: > All the problems you've listed makes it look like your data is text, not > numbers. > > What happens when you simple enter a number like 10 in, say, B3? Does your > sum change to 10? If so, it means your range contains text, not numbers. > That's what you have to fix. > > Regards, > Fred > > "kmg" <kmg(a)discussions.microsoft.com> wrote in message > news:755EF622-D1D5-4381-AC1B-1CF4983F3D6A(a)microsoft.com... > >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. > > . > |