How can I do calculations on multiple fields on multiple worksheets

**FDibbins** · 12-19-2013, 11:59 PM

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

**rgreene** · 12-20-2013, 11:01 AM

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