View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default Function - counting based on criteria

=countif(A1:A100,"<=60")
=countif(A1:A100,"60")
=countblank(A1:A100)

"Candace" wrote:

I have a column of numbers. I need 3 formulas: (1) to count the numbers that
are 1 to 60, (2) to count the numbers that are 61 or more (3) to count the
rows in the column that are blank. Any assistance would be greatly
appreciated. Thanks.