adding worksheet

[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

 

[Gbonda]

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

 

[Peter Atherton]

-----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

mike

Is this want you want?

=SUM(Sheet1:Sheet3!K12)

Regards
Peter