Count if with multiple condilition

[Jewnaa]

Class/Subject	Urdu	English	Math	Science	S.St	Drawing	General
One
Two

Please guide me how to count weekly subject count against each class.
Thanks

Class	Day	1	2	3	4	5	6	7	8
One	Monday	Urdu	English	Science	Math
One	Tuesday	Urdu	English	Science	Math
One	Wednesday	Urdu	English	Science	Math
One	Thursday	Urdu	English	Science	Math
One	Friday	Urdu	S.St.	Science	Math
One	Saturday	Urdu	S.St.	Science	Math
Two	Monday	Urdu	English	Science	Math
Two	Tuesday	Urdu	English	Science	Math
Two	Wednesday	Urdu	S.St.	Science	Math
Two	Thursday	Urdu	S.St.	Science	Math
Two	Friday	Urdu	English	Science	Math
Two	Saturday	Urdu	S.St.	Science	Math

 

[awoohaw]

try:
(Note: you're missing a period on S.St in the lookup row)

Book1
	A	B	C	D	E	F	G	H	I	J
1	Class/Subject	Urdu	English	Math	Science	S.St.	Drawing	General
2	One	6	4	6	6	2	0	0
3	Two	6	3	6	6	3	0	0
4
5
6
7
8
9	Class	Day	1	2	3	4	5	6	7	8
10	One	Monday	Urdu	English	Science	Math
11	One	Tuesday	Urdu	English	Science	Math
12	One	Wednesday	Urdu	English	Science	Math
13	One	Thursday	Urdu	English	Science	Math
14	One	Friday	Urdu	S.St.	Science	Math
15	One	Saturday	Urdu	S.St.	Science	Math
16
17	Two	Monday	Urdu	English	Science	Math
18	Two	Tuesday	Urdu	English	Science	Math
19	Two	Wednesday	Urdu	S.St.	Science	Math
20	Two	Thursday	Urdu	S.St.	Science	Math
21	Two	Friday	Urdu	English	Science	Math
22	Two	Saturday	Urdu	S.St.	Science	Math
Sheet1

Cell Formulas
Range	Formula
B2:H3	B2	=SUMPRODUCT(($A2=$A$10:$A$22)*(B$1=$C$10:$J$22))

 

[Jewnaa]

Thanks, Sir for your quick guidance...

 

[awoohaw]

You're welcome. Best Wishes!