Adding values from worksheets

  • Thread starter Thread starter PasPer2
  • Start date Start date
P

PasPer2

Hello,

I have made a workbook with 13 sheets, 1 for every lunar pay period
work. I am hoping to create a running total on every page whereby
know how many hours i have worked all year.

The cell on every page is L6.

Any help is much appreciated.

Regards

PasPer
 
Hi

One way is to insert a sheet (hidden if necessary) at the beginning and end
of the sheets you wish to sum. If you called these First and Last you could
use:
=SUM(First:Last!L6)
You could, of course, use the existing sheet names instead of First and
Last.
 
Back
Top