If the formula starts in row 1, use:
=COUNTIF(B:B,""&150+ROW()-1)
HTH
Jason
Atlanta, GA
-----Original Message-----
Using =COUNTIF(B:B,"150") I would like to autofill down
with the handle and
have the 150 increment up eg: 151 152 153 while the B:B
stays constant.
TIA, Dennis
==================
.
|