Counting cells

[QuizToon]

Hi,

I now how to count cells that contain certain numbers in a range but how do i count if a number appears in a certain selection of cells.

In the example below each there are 4 repeating columns.

I would want to count how many time a 7 appears in each column with the title "C" which would give the answer 2.
Is this possible to Achieve?

[TABLE="width: 496"]
<colgroup><col span="16"></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]7[/TD]
[TD]0[/TD]
[TD]7[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

Many Thanks

 

[Michael M]

Try using

=SUMPRODUCT(--(A1:P1="C")*(A2:P2=7))

 

[Aladin Akyurek]

=countifs(a1:q1,"c",a2:q2,7)