totalling up a bunch of non-contiguous, but columnar cells. cells contain
totals of the cells above them. the final total is returning a zero result.
What am I missing here - against my deadline?!
--
Claudia
__________________________________
"Age is...wisdom, if one has lived
one's life properly." --Miriam Makeba, singer
Pehaps calc mode is accidentally set to manual ?
Try pressing F9, does it now compute properly?
To quickly check / change the calc mode:
Click Tools > Options > Calculation tab
Ensure "Automatic" is checked > OK
If the above isn't it, post the final total formula
and maybe a sample of the other ones as well ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"ClaudCar" <[email protected]> wrote in message
news:xy8Zd.4940$mq2.3694@trnddc08...
> totalling up a bunch of non-contiguous, but columnar cells. cells contain
> totals of the cells above them. the final total is returning a zero
result.
> What am I missing here - against my deadline?!
>
> --
> Claudia
> __________________________________
> "Age is...wisdom, if one has lived
> one's life properly." --Miriam Makeba, singer
>
>
Also try checking the format of the cell. Set it to GENERAL to remove any formatting.
Mangesh
Another option is that the cells are formatted as text, and so they may look
like numbers but treated as strings.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Max" <[email protected]> wrote in message
news:%[email protected]...
> Pehaps calc mode is accidentally set to manual ?
>
> Try pressing F9, does it now compute properly?
>
> To quickly check / change the calc mode:
> Click Tools > Options > Calculation tab
> Ensure "Automatic" is checked > OK
>
> If the above isn't it, post the final total formula
> and maybe a sample of the other ones as well ..
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "ClaudCar" <[email protected]> wrote in message
> news:xy8Zd.4940$mq2.3694@trnddc08...
> > totalling up a bunch of non-contiguous, but columnar cells. cells
contain
> > totals of the cells above them. the final total is returning a zero
> result.
> > What am I missing here - against my deadline?!
> >
> > --
> > Claudia
> > __________________________________
> > "Age is...wisdom, if one has lived
> > one's life properly." --Miriam Makeba, singer
> >
> >
>
>
You can test this hypothesis by changing the SUM() function to COUNT(),
if it still returns zero, then the cells are text, not numbers.
Jerry
Bob Phillips wrote:
> Another option is that the cells are formatted as text, and so they may look
> like numbers but treated as strings.
And a quick way to convert those text numbers to number numbers is to copy an
empty cell, then select the offending range and do:
edit|paste special|and click the Add button.
Bob Phillips wrote:
>
> Another option is that the cells are formatted as text, and so they may look
> like numbers but treated as strings.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
> "Max" <[email protected]> wrote in message
> news:%[email protected]...
> > Pehaps calc mode is accidentally set to manual ?
> >
> > Try pressing F9, does it now compute properly?
> >
> > To quickly check / change the calc mode:
> > Click Tools > Options > Calculation tab
> > Ensure "Automatic" is checked > OK
> >
> > If the above isn't it, post the final total formula
> > and maybe a sample of the other ones as well ..
> > --
> > Rgds
> > Max
> > xl 97
> > ---
> > GMT+8, 1° 22' N 103° 45' E
> > xdemechanik <at>yahoo<dot>com
> > ----
> > "ClaudCar" <[email protected]> wrote in message
> > news:xy8Zd.4940$mq2.3694@trnddc08...
> > > totalling up a bunch of non-contiguous, but columnar cells. cells
> contain
> > > totals of the cells above them. the final total is returning a zero
> > result.
> > > What am I missing here - against my deadline?!
> > >
> > > --
> > > Claudia
> > > __________________________________
> > > "Age is...wisdom, if one has lived
> > > one's life properly." --Miriam Makeba, singer
> > >
> > >
> >
> >
--
Dave Peterson
THANK YOU ALL! I had opened it in a different version of Excel that didn't
have numbers as the default format. Now I can stop tearing my hair out at
such an easy solution.
--
Claudia
__________________________________
"Age is...wisdom, if one has lived
one's life properly." --Miriam Makeba, singer
"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> And a quick way to convert those text numbers to number numbers is to copy
an
> empty cell, then select the offending range and do:
>
> edit|paste special|and click the Add button.
>
>
>
> Bob Phillips wrote:
> >
> > Another option is that the cells are formatted as text, and so they may
look
> > like numbers but treated as strings.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> > "Max" <[email protected]> wrote in message
> > news:%[email protected]...
> > > Pehaps calc mode is accidentally set to manual ?
> > >
> > > Try pressing F9, does it now compute properly?
> > >
> > > To quickly check / change the calc mode:
> > > Click Tools > Options > Calculation tab
> > > Ensure "Automatic" is checked > OK
> > >
> > > If the above isn't it, post the final total formula
> > > and maybe a sample of the other ones as well ..
> > > --
> > > Rgds
> > > Max
> > > xl 97
> > > ---
> > > GMT+8, 1° 22' N 103° 45' E
> > > xdemechanik <at>yahoo<dot>com
> > > ----
> > > "ClaudCar" <[email protected]> wrote in message
> > > news:xy8Zd.4940$mq2.3694@trnddc08...
> > > > totalling up a bunch of non-contiguous, but columnar cells. cells
> > contain
> > > > totals of the cells above them. the final total is returning a zero
> > > result.
> > > > What am I missing here - against my deadline?!
> > > >
> > > > --
> > > > Claudia
> > > > __________________________________
> > > > "Age is...wisdom, if one has lived
> > > > one's life properly." --Miriam Makeba, singer
> > > >
> > > >
> > >
> > >
>
> --
>
> Dave Peterson
Dave Peterson wrote...
>And a quick way to convert those text numbers to number numbers is to
copy an
>empty cell, then select the offending range and do:
>
>edit|paste special|and click the Add button.
....
Unless those cells have numeric format Text, it'd be even quicker to
select the range and run Data > Text to Columns, select Fixed Width and
immediately click Finish in the first dialog of the text conversion
wizard.
The race is on!
<vbg>
Harlan Grove wrote:
>
> Dave Peterson wrote...
> >And a quick way to convert those text numbers to number numbers is to
> copy an
> >empty cell, then select the offending range and do:
> >
> >edit|paste special|and click the Add button.
> ...
>
> Unless those cells have numeric format Text, it'd be even quicker to
> select the range and run Data > Text to Columns, select Fixed Width and
> immediately click Finish in the first dialog of the text conversion
> wizard.
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks