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" <[email protected]> wrote in message
news:[email protected]...
>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