Countif

[bamaisgreat]

I need to edit the code below so it stops counting when it hits 0. SUggestions?

=COUNTIF(K5:K29,"<=30")

 

[Fluff]

Can you please explain what you mean?
Te formula will never "Hit zero" unless there are no cells that match the criteria.

 

[bamaisgreat]

The range of numbers its looking are shown below. If the number is 0 or like a -123 I need it to not show those.

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 66"]
<colgroup><col></colgroup><tbody>[TR]
[TD]DAYS LEFT[/TD]
[/TR]
[TR]
[TD]167[/TD]
[/TR]
[TR]
[TD]868[/TD]
[/TR]
[TR]
[TD]-728[/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD]132[/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD]705[/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD]727[/TD]
[/TR]
[TR]
[TD]728[/TD]
[/TR]
[TR]
[TD]1051[/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD]167[/TD]
[/TR]
[TR]
[TD]867[/TD]
[/TR]
[TR]
[TD]868[/TD]
[/TR]
[TR]
[TD]1463[/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[/TR]
[TR]
[TD]73[/TD]
[/TR]
[TR]
[TD]705[/TD]
[/TR]
[TR]
[TD]1051[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Paul Ked]

=countifs(k5:k29,">0",k5:k29,"<=30")