>>>I have a spreadsheet with 650 pages
>>>I need to get a total of all pages
>>>page 1 is an index sheet with links to all individual sheets. I would like toadd a column and see all for each page a total of column F1:f64000
>>>
>>>is that possible?
>>>
>>>Peter
>>
>>You could use a sum with the range: =sum(f1:f64000), but there is also a special syntax for the column: =sum(f:f). This is automatically generated if you type =sum( and then click on the column header. Of course the formula must be in a column other than F, to avoid a circular formula.
>I need to create the sum on sheet1 for columns on sheets2 through 650 (and the sheet names are dates like 51505,101206 etc.)
>
>
>sort of a total page
>
>i imported all pages (except the index) into VFP tables and want to verify the totals to make sure I got everything :-)

I see. Sorry, I don't know any special shortcut in Excel to sum the same cell, or the same column, in multiple sheets.

Update: The following seems to work fine:

=SUM(Sheet1:Sheet5!F:F)