PDA

View Full Version : Reference across sheets



noomi
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.

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