best to put in the same place and us
=sum(sheet1:sheetfinal!a1)
or
=sheet1a2+sheet2!a6 etc

--
Don Guillett
SalesAid Software

"dmedina" wrote in message
...
Hi
I would like to know how do you add certain cells in different worksheets
when they are not identical sheets. For example, I am adding up totals in
all
the sheets, but the total cell is in a different place in each sheet.