In cell J4 on sheet 12 type =sum(
Click on Sheet 1
Click in cell J4 (on sheet1)
While hold the shift key on the keyboard click on sheet11 (don't click any
cell)
Let go of shift
Type )
Press enter.

This will enter the following formula into your spreadsheet
=SUM(Sheet1:Sheet11!J4)

You can also type the formula directly.

"Tee" wrote:

My company uses excel to budget our labor cost. I want to have the same cell
in multiple sheets (Sheet 1 J4, Sheet 2 J4, through Sheet 12 J4) to add
together in Sheet 12 J4. What are the steps that I need to take in order
for the cells to add?