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 ?