I am preparing a weekly time-table for my school which looks like the following

The even rows contains course names, whereas the odd rows contain the teacher initials. Observe that a same paper is taken by more than one teacher (e.g., C10 C11 and G10 G11). I need to count the *total number of classes per course per teacher * in a week. Please help me to achieve that.

My efforts so far have been very inefficient.

I calculated the formula in B71 for each row in the entire time-table and added all the quantities in B70. However I need to have a comprehensive list of all courses with divisions for all teachers. I am not being able to generate that.

Thanks in advance.

CodePudding user response：

You where pretty close in your attempt. You could use the following in B70 and fill down and to the right: =COUNTIFS($C$10:$P$67,$A70,$C$11:$P$68,B$69)