adding worksheet

  • Thread starter Thread starter mike clay
  • Start date Start date
M

mike clay

i am trying to add sheet 1 k12 to sheet 2 k12 and getting
a total thin adding sheet 2 k12 to sheet 3 k12 and
getting a total and so on and so on. i know there is a
simple answer
please help
mike
 
Hi,

=SUM(Sheet1:Sheet3!K12)


Directions -

In the cell you want the total type in =sum(

click in sheet 1 K12 then hold down shift as you click on the othe
sheets.


Gre
 
-----Original Message-----
i am trying to add sheet 1 k12 to sheet 2 k12 and getting
a total thin adding sheet 2 k12 to sheet 3 k12 and
getting a total and so on and so on. i know there is a
simple answer
Click to expand...

mike

Is this want you want?

=SUM(Sheet1:Sheet3!K12)

Regards
Peter
 
Back
Top