There's another technique that can work also.

Go to the cell that you want to have be the total total. (yeah it's late
here)

type in =sum(

Then select your 1st sheet and the cell that you want. I believe you said H1.

=sum(sheet1!h1,

Once you've selected that sheet, and that cell, type a , and go to your next
one. Then do another , until you're done selecting all the cells you want
totaled across all the sheets.

There's more to tell you but I'm having trouble conjugating my thoughts let
alone verbalizing my type.

I hope this much helps



"WmBrown" wrote:

I am looking for a fomula or the method to add the total from a
particular cell in 5 sheets and enter it in a paticular cell on a 6th sheet.

I obtained a total on each sheet by =sum(A1:G1)and entered it in H1
Now I want to add H1 on the 5 separate sheets to give a total in a cell
on the 6th sheet.

Thanks for any help