Excel Question

[Dubya1]

So I am being lazy...
I want to total a specific line on multiple sheets. how do I write the the formula?

 

[JunkCJ6]

=sum(sheet!cell:sheet!cell)

 

[Dubya1]

Thank you, saved me a ton of time.

 

[Lilyota]

Just so you know if you want to subtract you do the same thing (still use =sum). For multiplying, if you ever need to, =product is what you start the formula with.