Results 1 to 2 of 2

Thread: Calculating Formula's

  1. #1

    Calculating Formula's



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

    Hi there. I am hoping someone can assist me.

    I need to create a excel sheet for attendance.

    I have attached what I have done thus far but what I want to do is count the number of times the words rescheduled, excused and did not show for each team leader.

    So if someone from Jonh's team does not come I want the formula to read that John had one person that did not show.

    Any idea?

    I did include a validation for the drop down arrpw for the reasons now I want to link the reason to the Team leaders name.
    Attached Files Attached Files

  2. #2
    Use

    =COUNTIFS($B$43:$B$52,B$54,$C$43:$C$52,$A55)

Posting Permissions

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