software

I have created 13 worksheets. My 13th sheet is my quot;Totals Sheetquot;. What
formula do i use to add cell quot;AG13quot; from sheet1-sheet12?

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

quot;Johnny Dquot; wrote:

gt; I have created 13 worksheets. My 13th sheet is my quot;Totals Sheetquot;. What
gt; formula do i use to add cell quot;AG13quot; from sheet1-sheet12?

Hi Johnny

Try this
=SUM(Sheet1:Sheet12!AG13)

--
Regards Ron de Bruin
www.rondebruin.nlquot;Johnny Dquot; gt; wrote in message ...
gt;I have created 13 worksheets. My 13th sheet is my quot;Totals Sheetquot;. What
gt; formula do i use to add cell quot;AG13quot; from sheet1-sheet12?
When i copy and past this, as soon as i hit quot;enterquot;, a popup comes up and
says quot;macros disabled. please close this workbook and reopen with macros
enabled....HELP?????

quot;Ron de Bruinquot; wrote:

gt; Hi Johnny
gt;
gt; Try this
gt; =SUM(Sheet1:Sheet12!AG13)
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;Johnny Dquot; gt; wrote in message ...
gt; gt;I have created 13 worksheets. My 13th sheet is my quot;Totals Sheetquot;. What
gt; gt; formula do i use to add cell quot;AG13quot; from sheet1-sheet12?
gt;
gt;
gt;

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

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

--
Regards Ron de Bruin
www.rondebruin.nlquot;Johnny Dquot; gt; wrote in message ...
gt; When i copy and past this, as soon as i hit quot;enterquot;, a popup comes up and
gt; says quot;macros disabled. please close this workbook and reopen with macros
gt; enabled....HELP?????
gt;
gt; quot;Ron de Bruinquot; wrote:
gt;
gt;gt; Hi Johnny
gt;gt;
gt;gt; Try this
gt;gt; =SUM(Sheet1:Sheet12!AG13)
gt;gt;
gt;gt; --
gt;gt; Regards Ron de Bruin
gt;gt; www.rondebruin.nl
gt;gt;
gt;gt;
gt;gt; quot;Johnny Dquot; gt; wrote in message ...
gt;gt; gt;I have created 13 worksheets. My 13th sheet is my quot;Totals Sheetquot;. What
gt;gt; gt; formula do i use to add cell quot;AG13quot; from sheet1-sheet12?
gt;gt;
gt;gt;
gt;gt;