View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charlie510 Charlie510 is offline
external usenet poster
 
Posts: 6
Default Counting cells with multiple criteria

I'm trying to count the number of cells that meet criteria in multiple columns:

Column AI contains a job number
Column AJ contains "blank", "0", or "-1"
Column AM contains the mm/dd/yyyy the job was finished

I need a COUNT of the cells in AJ that = "-1" and for which the job was
finished in a certain month