sum between workshhets
 

Hi all,
Feel like a goose used to do this dozens of times but cant get it
right ( its been a while ), I need to sum say cell a20 across ( between ) a
range of worksheets, I have setup the following
A
1
2
3
Z
RESULT SHEET

On the result sheet I want to sum in cella20 any entries on worksheets 1-3.

cheers
Pete
--
(][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)

Hi,

Use

=SUM('1:3'!A20)

Regards

Govind

OZDOC1050 wrote:
Hi all,
Feel like a goose used to do this dozens of times but cant get it
right ( its been a while ), I need to sum say cell a20 across ( between ) a
range of worksheets, I have setup the following
A
1
2
3
Z
RESULT SHEET

On the result sheet I want to sum in cella20 any entries on worksheets 1-3.

cheers
Pete

thankyou,
appreciated.

--
(][ THIS EMAIL HAS BEEN SCANNED BY NORTON ANTIVIRUS ][)
"Govind" wrote in message
...
Hi,

Use

=SUM('1:3'!A20)

Regards

Govind

OZDOC1050 wrote:
Hi all,
Feel like a goose used to do this dozens of times but cant get
it right ( its been a while ), I need to sum say cell a20 across (
between ) a range of worksheets, I have setup the following
A
1
2
3
Z
RESULT SHEET

On the result sheet I want to sum in cella20 any entries on worksheets
1-3.

cheers
Pete