EXCEL FORMULA PROBLEM?

Alternatively if your sheets are in "name order", use a 3-D formula:

=SUM(Sheet1:Sheet12!J2)

Select the cell you want to use. Now type

=SUM(

then with your mouse select J2 on the first sheet you want to total, then type a comma, then with your mouse select the next sheet tab and click in J2, and so on. Type a comma after each cell, except at the end of the process when you type a right bracket ).

select the cell you want the answer in.

enter "=" in the cell (Without the quotes)

Now click the total cell on the current sheet

Now enter a + after the cell address

Now click on the tab for the next sheet, then click its total cell

now enter + again

Keep repeating the previous two lines till you've done them all

The formula should look something like this

=B2+Sheet2!B2+Sheet3!B2

Hope that helps

click into the cell you want and then press = and then click onto each cell from the individual sheet and cell and put + between them. i think, that's what i did.