how can i have totals from one sheet automatically placed on anot

I cannot figure out how to have totals from one sheet to be recorded in a
cell on a different sheet in the same workbook

=SUM(Sheet1!A1:A30)

--
Regards,

Peo Sjoblom

(No private emails please)


"gvj" <gvj@discussions.microsoft.com> wrote in message
news:694B7367-AAF3-4B48-8202-2BC1D12E779C@microsoft.com...
>I cannot figure out how to have totals from one sheet to be recorded in a
> cell on a different sheet in the same workbook