Make sure the cell with the formula is formatted as GENERAL at first. Enter
your formula *then* change the format if you'd like.

Try this formula:

=SUM('EX1:EX3'!C19)

--
Biff
Microsoft Excel MVP


"snowboardbaltimore" wrote in
message ...
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?