Adding values from worksheets

[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

 

[Andy B]

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.