AutoSum problems

[Shaundra]

I'm having trouble with autosum on imported data. I've
imported a 4,000 line table from access to excel and when
I try to use the autosum feature, I get a error message
for 'circular references'; and I also can't get rid of
the 'smart tags' even if I go into 'tools, auto correct,
smart tags'; also when I manual type in the function
Ex: '=sum(range)' it just fills the cell with the sum of
the first cell of the range I'm interested in. Any
suggestions? I can't possible add these on the adding
machine, not this year anyway .

 

[Frank Kabel]

Hi
if you enter the formula manually like
=SUM(A1:A1000)
this should work if the values in this range are stored as numbers

 

[Shaundra]

I noticed I did have all the numbers in the column in red
font (and the red for negative numbers was on in the
format cells dialogue box, but its still not working even
though I've remedied that)?

-----Original Message-----
From: Sibert, Shaundra (NIH/NIAID)
Sent: Friday, April 09, 2004 8:01 AM
To: 'Frank Kabel'
Subject: RE: Re: AutoSum problems

With your formula, only the top cell is returning a value
of 'TRUE' - but I've highlighted the entire range, gone
into 'format cells' and changed it to 'number' several
times - Always only the top cell changes instead of the
entire range. Please help! I need to pass this into my
boss and I'll have to add about 3,000 pay lines by hand
if I don't figure this out soon!! Ahhh!

-----Original Message-----
From: Frank Kabel [mailto:[email protected]]
Sent: Wednesday, April 07, 2004 12:07 PM
To: Sibert, Shaundra (NIH/NIAID)
Subject: Re: Re: AutoSum problems

Hi
are your sure your values are stored as numbers and not
as text. e.g. if you
have cell A1 in this range enter the formula
=ISNUMBER(A1)
does this return TRUE?
--
Regards
Frank Kabel
Frankfurt, Germany
----- Original Message -----
From: "Sibert, Shaundra (NIH/NIAID)"
<[email protected]>
To: "'Frank Kabel'" <[email protected]>
Sent: Wednesday, April 07, 2004 5:11 PM
Subject: RE: Re: AutoSum problems

 

[Frank Kabel]

Hi
try the following:
- select an empty cell and copy this cell (with CTRL+C)
- select your range of numbers (which are probably stored as 'Text')
- goto 'Edit - Paste Special' and choose the action 'Add'

this should convert the values into real numbers. Now try the SUM
function
again.

If this does not help you may mail me your file

--
Regards
Frank Kabel
Frankfurt, Germany

I noticed I did have all the numbers in the column in red
font (and the red for negative numbers was on in the
format cells dialogue box, but its still not working even
though I've remedied that)?

-----Original Message-----
From: Sibert, Shaundra (NIH/NIAID)
Sent: Friday, April 09, 2004 8:01 AM
To: 'Frank Kabel'
Subject: RE: Re: AutoSum problems

With your formula, only the top cell is returning a value
of 'TRUE' - but I've highlighted the entire range, gone
into 'format cells' and changed it to 'number' several
times - Always only the top cell changes instead of the
entire range. Please help! I need to pass this into my
boss and I'll have to add about 3,000 pay lines by hand
if I don't figure this out soon!! Ahhh!

-----Original Message-----
From: Frank Kabel [mailto:[email protected]]
Sent: Wednesday, April 07, 2004 12:07 PM
To: Sibert, Shaundra (NIH/NIAID)
Subject: Re: Re: AutoSum problems

Hi
are your sure your values are stored as numbers and not
as text. e.g. if you
have cell A1 in this range enter the formula
=ISNUMBER(A1)
does this return TRUE?

Yeah that worked but its giving me a '0' sum, and its about a billion
dollars I'm dealing with here. I formatted everything as 'numbers" as
suggested and put in the simple range????

Original Message-----
From: "Frank Kabel" <[email protected]>
Sent: 4/7/2004 6:46:02 AM
Subject: Re: AutoSum problems

Hi
if you enter the formula manually like
=SUM(A1:A1000)
this should work if the values in this range are stored as numbers

--
Regards
Frank Kabel
Frankfurt, Germany



-----Original Message-----
Hi
if you enter the formula manually like
=SUM(A1:A1000)
this should work if the values in this range are stored as numbers

--
Regards
Frank Kabel
Frankfurt, Germany


.