Hi Liana

Your sheet order should be
Summary Sheet with your Sum formula
First (Blank)
Sheet1
..
..
Sheet19
Last (Blank)

The Summary sheet can be before First, or after Last, but should not be in
between.
--

Regards
Roger Govier

"Liana" wrote in message
...
I have managed to get a total for one sum but if I try with the other 2
totals in the same way I still get a zero figure..

"David Biddulph" wrote:

You missed out a small but important exclamation mark.
It should be =SUM(first:last!B48)
--
David Biddulph

"Liana" wrote in message
...
=SUM(first:lastB48), I also tried sum= () to which I clicked on every
persons monthly total cell & hoped to get an answer - still no luck

"David Biddulph" wrote:

Exactly what did your formula look like?
--
David Biddulph

"Liana" wrote in message
...
I am trying to sum totals from 19 pages, I have entered 2 dummy
sheets
at
the
beginning & end & now want monthly totals. each worksheet has
monthly
totals
but I need the overall month for the whole team, I tried
sum(first:last
cell
number) but the answer is zero - what am I missing ?