PDA

View Full Version : Calculating Formula's



Alltorc
2011-09-07, 04:02 PM
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.

Bob Phillips
2011-09-07, 05:03 PM
Use

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