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.
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.
[VBA]=SUMPRODUCT(--(INDIRECT("'" & A4 & "'!K3:K99")=Sheet4!$A$3),INDIRECT("'" & A4 & "'!L3:L99"))[/VBA]
in C4 and copy down.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Try
=SUMIF(INDIRECT("'"&$A4&"'!K:K"),$A$3,INDIRECT("'"&$A4&"'!L:L"))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thank you very much p45cal. That did the trick. I appreciate your help very much.
So does the SUMIF, and SUMIF is far more efficient than SUMPRODUCT.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber