I am trying to sum the totals (in accounting number format) across multiple
worksheets onto a single worksheet. I have tried manually creating the
necessary formula (='ex1'!c19+'ex2'!c19+'ex3'!c19+....), and also copying th
formula from a previous worksheet. No matter how I do this, the formula stays
visible and does not calculate or become anything more than text. Is there
any other way to sum across multiple pages?