try
=sumproduct((b2:b22=12)*(b2:b22<=29))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fred Loh" wrote in message
...
i have a column (column B) of cells with numbers in the cells. i want to
count for. example, how many cells have a number between 12 and 29. i used
=countif(B:B,"=12 and <=29") but it did not work.
=countif(B:B,"=12,<=29")
also did not work. what is the correct syntax for the criteria in the
formula?

thanks for your help
fred