View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Kline[_2_] Don Kline[_2_] is offline
external usenet poster
 
Posts: 28
Default Stopping a CountIf

In a column I need to count how many rows from the start of the column are
greater then zero. The trick is once the value is a 0 or a negative, it is to
stop counting.

Maximum number is 121.

I have a macro that does this but am looking for a way to do this through a
formula.