count cells in matrix

[AnnieD]

Dear all
I'm looking for a formula to count the number of cells which contain a certain criteria, and only when it match the criteria for a certain row.
I have the table below, and would like to count the following:
How many cells contain fe.:
DR an have T5 in a row = answer = 1
RW and have T15 in a row = answer = 10

Thanks in advance for your help!!


[TABLE="width: 512"]
<colgroup><col width="64" style="width:48pt"> <col width="64" style="width:48pt"> <col width="64" span="6" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="class: xl72, width: 64"]A[/TD]
[TD="class: xl72, width: 64"]B[/TD]
[TD="class: xl72, width: 64"]C[/TD]
[TD="class: xl72, width: 64"]D[/TD]
[TD="class: xl72, width: 64"]E[/TD]
[TD="class: xl72, width: 64"]F[/TD]
[TD="class: xl72, width: 64"]G[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="class: xl66, align: center"]Tasks[/TD]
[TD="class: xl71"]AM[/TD]
[TD="class: xl71"]PM[/TD]
[TD="class: xl71"]AM[/TD]
[TD="class: xl71"]PM[/TD]
[TD="class: xl71"]AM[/TD]
[TD="class: xl71"]PM[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="class: xl67"]T15[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl68"]RW[/TD]
[TD="class: xl69"]RW[/TD]
[TD="class: xl68"]RW[/TD]
[TD="class: xl69"]RW[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="class: xl67"]T15[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl68"]RW[/TD]
[TD="class: xl69"]RW[/TD]
[TD="class: xl68"]RZ[/TD]
[TD="class: xl69"]RZ[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="class: xl67"]T15[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl68"]RW[/TD]
[TD="class: xl69"]RW[/TD]
[TD="class: xl68"]RW[/TD]
[TD="class: xl69"]RW[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="class: xl67"]T11[/TD]
[TD="class: xl69"]DR[/TD]
[TD="class: xl69"]DR[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="class: xl67"]T18[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]DR[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="class: xl67"]T5[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl69"]DR[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Maybe

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K
1	Tasks	AM	PM	AM	PM	AM	PM			T15
2	T15			RW	RW	RW	RW			RW	10
3	T15			RW	RW	RZ	RZ
4	T15			RW	RW	RW	RW
5	T11	DR	DR
6	T18			DR
7	T5				DR
Ex

Cell Formulas
Range	Formula
K2	=SUMPRODUCT((A2:A7=J1)*(B2:G7=J2))