HELP! sum value to be displayed in sheet 2 when data is in sheet 1

[Muppet]

How do I do this? any ideas

 

[Peo Sjoblom]

=SUM(Sheet1!A1:A100)

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[pikapika13]

=SUM(Sheet1!$A:$A) as an example for sum of Column A in Sheet1