totaling cells in a workbook.

  • Thread starter Thread starter ryan
  • Start date Start date
R

ryan

I am trying to add cells in a workbook. It won't let me
enter the function =SUM('sheet1'!A1:'sheet30!'A1)

I have to enter the formula as =SUM('sheet1'!A1,
'sheet2'!A1, 'sheet3'!A1, etc.) and I can only enter 30
sheets.

Is there and easier way to do this? Can I add more than
30 sheets? Any feedback would be appreciated.
thanks
 
Ryan, enter the function like this: =SUM(Sheet2:Sheet30!A1). I think the
problem is in your syntax, not in the number of sheets.
 
Easiest way to do it is to type =SUM( then click on cell A1 on sheet 1, hold
down SHIFT and then click on cell A1 in your last sheet, then type the lcosing
parenthesis and hit Enter. This will ensure you get the correct syntax.
 
Back
Top