View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dribler2 dribler2 is offline
external usenet poster
 
Posts: 96
Default how to count by a "generic" formula

Col A
0
1
3
6
7
9
11
in series
------------

in B1=countif(colA=<C1)

in C1 is the formulated result e.g 10 always positive.

Count result = 6

thanks
dribler2