>>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 :-)




Peter