Can I do a forumla =sum(range of cells on a different sheet)?
Create the Formula in the sheet with thedata and then link the result to the main sheet using link cells.
