Calculating Formula's

Alltorc

New member
Joined
Sep 7, 2011
Messages
1
Reaction score
0
Points
0
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.
 

Attachments

  • 2011 employee absence schedule.xlsm
    35.7 KB · Views: 18

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Use

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