count a number of classes for a teacher

[aysam]

Hi all
I need a formula to count the number of lessons for a class given by a teacher
the range = A1 : Z100
the teacer : teacher 1
the class : 1/ 1

 

[DanteAmor]

It's not clear to me where you want the result or what you want to count.
But I show you a formula to count how many "1/ 1" there are, check if it works for you.

varios 07sep2024.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1
2	1	2	3	4	5	6	7	8	1	2	3	4	5	6	7	8	1	2	3	4	5	6	7	8
3			1/ 1	1/ 1	2/ 2	2/ 2											1/ 1	1/ 1								8		teacher 1
4			2/ 2	2/ 2	2/ 2	2/ 2				2/ 2	2/ 2
5	1/ 1	1/ 1	1/ 1	1/ 1						2/ 2	2/ 2							2/ 2	2/ 2	2/ 2	2/ 2	2/ 2
6
7
8	2/ 2	2/ 2	2/ 2
9
10
Hoja2

Cell Formulas
Range	Formula
Z3	Z3	=SUMPRODUCT((A3:X9="1/ 1")*1)

----- --
Let me know the result and I'll get back to you as soon as I can.
Sincerely
Dante Amor
----- --