Try a formula of
=SUMPRODUCT(--(Raw!$D$2:$D$101=$E9),--(Raw!$B$2:$B$101=F$7))
in your table.
Hello all,
I work for a contact center. My job includes coaching and mentoring my team members. I document my coaching observations in excel file. I want to automate the task of capturing coaching numbers in the table in adjacent. If a do a coaching for particular team member for a particular day, the number of coaching done should automatically appear in the next sheet next to his name. Please review the attached file.
Thank you in advance for your help and suggestions.
Thanks & regards,
NagarajApr14.xls
Try a formula of
=SUMPRODUCT(--(Raw!$D$2:$D$101=$E9),--(Raw!$B$2:$B$101=F$7))
in your table.
Bookmarks