Sum of cell on numerous worksheets in a workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created 13 worksheets. My 13th sheet is my "Totals Sheet". What
formula do i use to add cell "AG13" from sheet1-sheet12?
 
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?????
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic Sumning of Same Cell from Different Sheets 3
need help with a formula 18
sum accross worksheets using names 1
Formula for average of cells that have blanks 1
Referencing another workbook using a variable for the sheet? 20
Totalling sequential worksheets 1
Summing multiple account #s in one cell, by referencing 4
Adding data from multiple worksheets onto a total's page?? 4

Back
Top