Sum of cell on numerous worksheets in a workbook
 

I have created 13 worksheets. My 13th sheet is my "Totals Sheet". What
formula do i use to add cell "AG13" from sheet1-sheet12?

Sum of cell on numerous worksheets in a workbook
 

=SUM('Sheet 1:Sheet12'!G13)

"Johnny D" wrote:

I have created 13 worksheets. My 13th sheet is my "Totals Sheet". What
formula do i use to add cell "AG13" from sheet1-sheet12?

Sum of cell on numerous worksheets in a workbook
 

Hi Johnny

Try this
=SUM(Sheet1:Sheet12!AG13)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Johnny D" wrote in message ...
I have created 13 worksheets. My 13th sheet is my "Totals Sheet". What
formula do i use to add cell "AG13" from sheet1-sheet12?

Sum of cell on numerous worksheets in a workbook
 

When i copy and past this, as soon as i hit "enter", a popup comes up and
says "macros disabled. please close this workbook and reopen with macros
enabled....HELP?????

"Ron de Bruin" wrote:

Hi Johnny

Try this
=SUM(Sheet1:Sheet12!AG13)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Johnny D" wrote in message ...
I have created 13 worksheets. My 13th sheet is my "Totals Sheet". What
formula do i use to add cell "AG13" from sheet1-sheet12?

Sum of cell on numerous worksheets in a workbook
 

This is a worksheet function and you copy this in a cell

I reply to your private post with this
=SUM('Jan 06:Dec 06'!AJ15)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Johnny D" wrote in message ...
When i copy and past this, as soon as i hit "enter", a popup comes up and
says "macros disabled. please close this workbook and reopen with macros
enabled....HELP?????

"Ron de Bruin" wrote:

Hi Johnny

Try this
=SUM(Sheet1:Sheet12!AG13)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Johnny D" wrote in message ...
I have created 13 worksheets. My 13th sheet is my "Totals Sheet". What
formula do i use to add cell "AG13" from sheet1-sheet12?