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

how to count by a "generic" formula
 

=countif(A:A,"<="&C1)

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

"dribler2" wrote in message
...
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