Adding numbers

[suet]

Hi I have a spreadsheet whereby I need to add numbers together from
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:A
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

 

[Bob Phillips]

or even

=SUM(A1:A3,A7:A9)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

Your Excel is optimistic

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

HTH

 

[suet]

Hiya

Thank you very much for your help and quick response.

Regards
Sue