Excel formula problem?

This is where you need to use what is called external references. Rather than trying to remember the name, path, and cell reference of the other sheets, have all relevant workbooks open and up to Window, Arrange and have them vertically arranged. Then in the worksheet cell where you want the total start off the formula by inputting the =sign then double click on the relevant cells in the other workbooks to put their cell references in your formula. If you are merely taking what are already totals, i.e. individual cells from each of the other works books, when double clicking in the first, add the mathematical operator + before double clicking on the next. If, however you are adding up a range of figures then you need to start the function off with =sum( and then highlight the range of figures in the other workbooks). You will see that when you use external formulas in this way, you get the workbook name and path, the sheet name followed by exclamation mark which denotes it being external to the current worksheet, and then finally the cell reference/s. Hope this helps.

Open all the files you want to total. In the total cell type

=SUM(

then go to the first file and click in the cell, type a comma,

then go to the second file and do the same until you have completed the formula. Finish by typing a closing bracket )

Your formula should look like this:-

=SUM([file1]sheet1!$A$1,[file2]sheet1!$A$1,

... and so on.

You can cycle through files with Alt-Tab.

JUst the same as you do normaly. The easiest way is to open all the files and total all the relevant cells where you want it. Excel will automatically create a link to all the relevant files in the sum cell...

Whaaaaaaaaaaaaaaaaat?