Need hep to automate task using formula

[Nagaraj475]

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

[Bob Phillips]

Try a formula of

=SUMPRODUCT(--(Raw!$D$2:$D$101=$E9),--(Raw!$B$2:$B$101=F$7))

in your table.

[Nagaraj475]

Try a formula of

=SUMPRODUCT(--(Raw!$D$2:$D$101=$E9),--(Raw!$B$2:$B$101=F$7))

in your table.

Hello Bob,

That worked! I did not know about this particular function of Excel. Thanks so much for sharing your expertise. People like you make this world beautiful....

Thanks again,
Nagaraj