Match criteria in Column A and count amount of remaining cells below

[Addictions]

Hello,

I would like to match and find a criteria in column A from C1 cell, and then calculate how many cells has values below with including the found one.
By looking at the table below it should return count of 4.
Much appreciate your help.

[TABLE="width: 279"]
<colgroup><col><col span="4"></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="colspan: 2"]Current Week[/TD]
[TD="colspan: 2"]29[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Week[/TD]
[TD]Data 1[/TD]
[TD]Data 2[/TD]
[TD]Data 3[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]24[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]25[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]26[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]27[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]28[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]29[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]30[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]31[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]32[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD]9[/TD]
[/TR]
</tbody>[/TABLE]

 

[navic]

try

=COUNTIF(A3:A11,">="&C1)

 

[Addictions]

Please ignore I found the way of doing it:

=COUNTIF($A$3:$A$11,">="&C1)

 

[Addictions]

try

=COUNTIF(A3:A11,">="&C1)

Thank you. I had a read through your explanations and figured it out that way
Really much appreciate your help !

 

[navic]

Okay, never mind.
You're welcome.