>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)