View Full Version : Reference across sheets

09-30-2012, 11:50 PM
I am trying to reference the tab name in Column A(Employee A, EmployeeB, Employee C, ....) of sheet F0301QA00810 to sum the total of each employee that has F0301QA00810 in column K by using sumproduct.

Bob Phillips
10-01-2012, 01:13 AM
Are you trying to sum across many sheets? What value/column are you trying to sum?