Hi

Try =SUM(Sheet1:Sheet5!N34)

--
Regards
Roger Govier
"salvo" wrote in message
...
NEED FORMULA PLEASE
I have a file with 6 work sheets. I would like to take the totals of the
first five work sheets and have a gtand total on the 6th work sheet
example
sheet 1 34N is $55:00
sheet 2 34N is $75.00
and so on
sheet 6 would have a geand total of the first two sheets $130.00