Adding numbers

[suet]

Hi I have a spreadsheet whereby I need to add numbers together from 2 areas.

A1: 1171
A2: 4202
A3: 1698
A4: 2801
A5: 4146
A6: 5100
A7: 5000
A8: 4287
A9: 4405

I want to enter a formula into A11 that allows me to add cells A1:A3 and A7:A9.

I have entered the following formula but get value# error:

=sum(A1:A3)+(A7:A9)

Sorry but my excel is not very good.

Thank you in advance for your help.

[Ardus Petus]

Your Excel is optimistic

=SUM(A1:A3)+SUM(A7:A9)

HTH
--
AP

"suet" <[email protected]> a écrit dans le
message de news:[email protected]...
>
> Hi I have a spreadsheet whereby I need to add numbers together from 2
> areas.
>
> A1: 1171
> A2: 4202
> A3: 1698
> A4: 2801
> A5: 4146
> A6: 5100
> A7: 5000
> A8: 4287
> A9: 4405
>
> I want to enter a formula into A11 that allows me to add cells A1:A3
> and A7:A9.
>
> I have entered the following formula but get value# error:
>
> =sum(A1:A3)+(A7:A9)
>
> Sorry but my excel is not very good.
>
> Thank you in advance for your help.
>
>
> --
> suet
> ------------------------------------------------------------------------
> suet's Profile:
http://www.excelforum.com/member.php...fo&userid=1071
> View this thread: http://www.excelforum.com/showthread...hreadid=531926
>

[Bob Phillips]

or even

=SUM(A1:A3,A7:A9)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ardus Petus" <[email protected]> wrote in message
news:[email protected]...
> Your Excel is optimistic
>
> =SUM(A1:A3)+SUM(A7:A9)
>
> HTH
> --
> AP
>
> "suet" <[email protected]> a écrit dans le
> message de news:[email protected]...
> >
> > Hi I have a spreadsheet whereby I need to add numbers together from 2
> > areas.
> >
> > A1: 1171
> > A2: 4202
> > A3: 1698
> > A4: 2801
> > A5: 4146
> > A6: 5100
> > A7: 5000
> > A8: 4287
> > A9: 4405
> >
> > I want to enter a formula into A11 that allows me to add cells A1:A3
> > and A7:A9.
> >
> > I have entered the following formula but get value# error:
> >
> > =sum(A1:A3)+(A7:A9)
> >
> > Sorry but my excel is not very good.
> >
> > Thank you in advance for your help.
> >
> >
> > --
> > suet
> > ------------------------------------------------------------------------
> > suet's Profile:
> http://www.excelforum.com/member.php...fo&userid=1071
> > View this thread:
http://www.excelforum.com/showthread...hreadid=531926
> >
>
>

[suet]

Hiya

Thank you very much for your help and quick response.

Regards
Sue

[suet]

Thank you very much

[AlKey]

Here is a simpler way

Please Login or Register  to view this content.

[jtakw]

Hi,

Already posted in 2006, check Post #3.

[suet]

Thank you.

Regards
Sue