J
Johnny D
I have created 13 worksheets. My 13th sheet is my "Totals Sheet". What
formula do i use to add cell "AG13" from sheet1-sheet12?
formula do i use to add cell "AG13" from sheet1-sheet12?
S
Sloth
=SUM('Sheet 1:Sheet12'!G13)
R
Ron de Bruin
Hi Johnny
Try this
=SUM(Sheet1:Sheet12!AG13)
Try this
=SUM(Sheet1:Sheet12!AG13)
J
Johnny D
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?????
says "macros disabled. please close this workbook and reopen with macros
enabled....HELP?????
R
Ron de Bruin
This is a worksheet function and you copy this in a cell
I reply to your private post with this
=SUM('Jan 06
ec 06'!AJ15)
I reply to your private post with this
=SUM('Jan 06
ec 06'!AJ15)