How can I do calculations on multiple fields on multiple worksheets

I have a payroll spreadsheet with each pay period recorded in a separate worksheet. I now have to find a way to calculate YE totals to calculate annual salaries, days absent, and calculate annual bonuses.

If you're just trying to get the YTD, or YE totals, you can just SUM all the cells with the specific data you're looking for.

Formula:

Please Login or Register  to view this content.

This formula would return the YTD salary on your sheet.

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