View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Loh Fred Loh is offline
external usenet poster
 
Posts: 3
Default countif criteria sg

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