PDA

View Full Version : Solved: referencing a tab name in a sumproduct formula



Melinda
12-18-2010, 05:06 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.

p45cal
12-18-2010, 07:37 PM
=SUMPRODUCT(--(INDIRECT("'" & A4 & "'!K3:K99")=Sheet4!$A$3),INDIRECT("'" & A4 & "'!L3:L99"))
in C4 and copy down.

Bob Phillips
12-19-2010, 03:40 AM
Try

=SUMIF(INDIRECT("'"&$A4&"'!K:K"),$A$3,INDIRECT("'"&$A4&"'!L:L"))

Melinda
12-19-2010, 05:19 PM
Thank you very much p45cal. That did the trick. I appreciate your help very much.

Bob Phillips
12-19-2010, 05:25 PM
So does the SUMIF, and SUMIF is far more efficient than SUMPRODUCT.