Results 1 to 3 of 3

Thread: Need hep to automate task using formula

  1. #1

    Need hep to automate task using formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Try a formula of

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

    in your table.

  3. #3
    Quote Originally Posted by Bob Phillips View Post
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •