in [Functions]

Prev: How to select other random cells
Next: ODBC Query
From: Anida on 23 Apr 2010 10:10 Despite formula I use (for example the most simple SUM) it always shows me zero result even it should show a lot more. Values in other cells (cells that I sum) are in number format. Why this happens??
From: "David Biddulph" groups [at] on 23 Apr 2010 10:27 It doesn't matter whether the cells are FORMATTED to DISPLAY as number; what matters is whether the CONTENTS are numbers. My guess is that they are text that might look like a number. If one of your numbers is in A2, what do the formulae =ISTEXT(A2) and =ISNUMBER(A2) show? -- David Biddulph "Anida" <Anida (a)discussions.microsoft.com> wrote in message news:4D40D583-5C85-4470-A427-EC5525D79EB5 (a)microsoft.com...> Despite formula I use (for example the most simple SUM) it always shows me > zero result even it should show a lot more. Values in other cells (cells > that > I sum) are in number format. Why this happens??
From: Max on 23 Apr 2010 22:32 This quick fix might suffice for you Instead of using: =SUM(A2:A5) use this, array-enter it, ie press CTRL+SHIFT+ENTER to confirm the formula: =SUM(A2:A5+0) The "+0" will coerce all text numbers (if any) within the source range (A2:A5) to real numbers w/o impacting their intrinsic values, and return the desired results. Happy? hit the YES below -- Max Singapore --- "Anida" wrote: > Despite formula I use (for example the most simple SUM) it always shows me > zero result even it should show a lot more. Values in other cells (cells that > I sum) are in number format. Why this happens??
From: Anida on 26 Apr 2010 04:43 When I put =isnumber(a2) it shows me true, and for =istext false. What next? "David Biddulph" wrote: > It doesn't matter whether the cells are FORMATTED to DISPLAY as number; > what matters is whether the CONTENTS are numbers. My guess is that they are > text that might look like a number. If one of your numbers is in A2, what > do the formulae =ISTEXT(A2) and =ISNUMBER(A2) show? > -- > David Biddulph > > > "Anida" <Anida (a)discussions.microsoft.com> wrote in message > news:4D40D583-5C85-4470-A427-EC5525D79EB5 (a)microsoft.com...> > Despite formula I use (for example the most simple SUM) it always shows me > > zero result even it should show a lot more. Values in other cells (cells > > that > > I sum) are in number format. Why this happens?? > > > . >
From: Dave Peterson on 26 Apr 2010 07:26
Make sure that calculation is set to automatic. In xl2003 menus: tools|options|calculation tab And your range to sum does include A2, right? Anida wrote: > > When I put =isnumber(a2) it shows me true, and for =istext false. What next? > > "David Biddulph" wrote: > > > It doesn't matter whether the cells are FORMATTED to DISPLAY as number; > > what matters is whether the CONTENTS are numbers. My guess is that they are > > text that might look like a number. If one of your numbers is in A2, what > > do the formulae =ISTEXT(A2) and =ISNUMBER(A2) show? > > -- > > David Biddulph > > > > > > "Anida" <Anida (a)discussions.microsoft.com> wrote in message> > news:4D40D583-5C85-4470-A427-EC5525D79EB5 (a)microsoft.com...> > > Despite formula I use (for example the most simple SUM) it always shows me > > > zero result even it should show a lot more. Values in other cells (cells > > > that > > > I sum) are in number format. Why this happens?? > > > > > > . > > -- Dave Peterson |