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

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - how can i have totals from one sheet automatically placed on anot (https://www.excelbanter.com/new-users-excel/43860-how-can-i-have-totals-one-sheet-automatically-placed-anot.html)

gvj

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

Peo Sjoblom

=SUM(Sheet1!A1:A30)

--
Regards,

Peo Sjoblom

(No private emails please)

"gvj" wrote in message
...
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

All times are GMT +1. The time now is 03:54 AM.