View Single Post
  #3   Report Post  
OZDOC1050
 
Posts: n/a
Default

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