Adding worksheets

M

mike clay

i am trying to add the sheet 1 K12 to sheet 2 k12 and get
a total and thin add sheet 2 k12 to sheet 3 k12 and get a
total and so on and so on.
if anyone can help please let me know
mike
 
P

Pete McCosh

Mike,

=sum('sheet1:sheet2'!K12)

you can modify this as required. The sum will add the
total of the range on all sheets between the first and
second named in the formula.

Cheers, Pete
 
Top