How can I do calculations on multiple fields on multiple worksheets

Originally Posted by FDibbins

A slightly shorter version perhaps...
=sum('week 1:week 3'!D2)

You can get this by...
1. enter =sum(
2. click on D2 in week 1
3. hold down the SHIFT
4. press enter

Excellent. This is perfect. Thanks.

Is there a way to use this worksheet range to select all employee names(Column A) from "week 1" to "week 3". I can then sort this list and remove duplicates to build list that includes all staff that have worked any pay periods for the year