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]
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]