View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kmc103 kmc103 is offline
external usenet poster
 
Posts: 3
Default Counting items in one column based on criteria in another

I'm trying to count the number of rows in a column which meet criteria
identified in another column. I'm creating a payroll template where one
column identifies whether the position is full-time or part-time. In my
first month of payroll I want to be able to count the number payroll amounts
which are classified as full-time. I also want to ignore any zeroes. Any
help would be greatly appreciated. In using Windows 2003