View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Judy Rose Judy Rose is offline
external usenet poster
 
Posts: 23
Default Multiple field count function use

I have a criteria where I want to count a line of data if one date field is
filled in and another date field is empty (I want it to count the phone
interview completed but not entered into the system). How do I establish
this? I have the one set up to count those entered through a countif
function but I don't want to double count those that have been contacted and
entered by using the same formula to count the ones contacted. I read the
previous threads but they do not address dates in particular as the criteria
used to determine whether or not to count the line of data.

Thank you for your assistance in advance.
--
Judy Rose Cohen