SIMPLE QUESTION need fast answer please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jannie - 05 Oct 2007 17:40 GMT

This worksheet has 5 columns of numbers when the columns are added =sum
formula to add down it always returns on a 1 as the sum total and not add the
entire column.

What is it doing and how do I fix it. Is it something global.

Jannie

Reply to this Message

Don Guillett - 05 Oct 2007 17:45 GMT

Please do NOT type in all caps and please don't ask for a fast answer. All
questions get equal billing.
And, please fully describe your problem with examples.
Could it be that you have calculation set to automatic?

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> This worksheet has 5 columns of numbers when the columns are added =sum
> formula to add down it always returns on a 1 as the sum total and not add
[quoted text clipped - 4 lines]
>
> Jannie

Reply to this Message

Jannie - 05 Oct 2007 17:54 GMT

Please explain what that is - set to automatic??

> Please do NOT type in all caps and please don't ask for a fast answer. All
> questions get equal billing.
[quoted text clipped - 9 lines]
> >
> > Jannie

Reply to this Message

Jannie - 05 Oct 2007 17:58 GMT

I figured it out. Tools, Option, Edit Enable, Auto Complete - needed disabled.
Thanks.

> Please explain what that is - set to automatic??
>
[quoted text clipped - 11 lines]
> > >
> > > Jannie

Reply to this Message

Peo Sjoblom - 05 Oct 2007 18:22 GMT

I don't think auto complete has anything to do with this, more likely either
calculation was set to manual under tools>options>calculation or the values
are/were text

Signature

Regards,

Peo Sjoblom

>I figured it out. Tools, Option, Edit Enable, Auto Complete - needed
>disabled.
[quoted text clipped - 18 lines]
>> > >
>> > > Jannie

Reply to this Message

Terry - 05 Oct 2007 17:49 GMT

Columns A B C D E

10    1    7    4    11
10    5    7    5    12
10    4    7    3    14
1    4    4    2    17
1    4    8    4    18
0    7    5    2    9
=SUM(A1:A5) ECT... =SUM(A7:E7)

Just include the cell reference along with the letter

> This worksheet has 5 columns of numbers when the columns are added =sum
> formula to add down it always returns on a 1 as the sum total and not add the
[quoted text clipped - 3 lines]
>
> Jannie

Reply to this Message

Jannie - 05 Oct 2007 17:51 GMT

I am but it still only returns the #1 for every column.
Jannie

> Columns A B C D E
>
[quoted text clipped - 15 lines]
> >
> > Jannie

Reply to this Message