SUMPRODUCT in payroll spreadsheet help

**Mr Zero** · 01-26-2005, 07:39 PM

Hello. I have a basic question. I currently have a spreadsheet that tracks the earnings of tipped employees for each week. Each worksheet of the workbook corresponds to a different pay period. I'd like to have a summary worksheet at the end of the book giving the total earnings for each employee. One issue is that the row position changes for each worker as the payroll expands and contracts. I thought of using the SUMPRODUCT function to accomplish the task using two variables (first and last name) as criteria.

=SUMPRODUCT((A1:A10="lastname")*(B1:B10="firstname")*(C1:C10))

where column A contains last names, column B contains first names, and column C contains total tips earned by each different employee (or row).

How can I make this work across multiple worksheets and give the sum of each weekly total?

Thanks for the help.

**Mr Zero** · 01-27-2005, 07:45 PM

Does anyone have a suggestion for making this work across worksheets or an alternative? Thanks.

=SUMPRODUCT((A1:A10="lastname")*(B1:B10="firstname")*(C1:C10))