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.

Signature
Judy Rose Cohen
T. Valko - 03 Mar 2008 21:47 GMT
This is very confusing:
>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.
Can you post a small example and the expected result?

Signature
Biff
Microsoft Excel MVP
>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
[quoted text clipped - 8 lines]
>
> Thank you for your assistance in advance.
Roger Govier - 04 Mar 2008 00:06 GMT
Hi Judy Rose
With first date in column A and second date in column B
=COUNTA(A:A)-COUNTIF(B:B,"<>")
The first part counts all the rows in column A with Dates, and the second
part deducts all those cells in column B which are not empty
Change ranges to suit.

Signature
Regards
Roger Govier
> I have a criteria where I want to count a line of data if one date field
> is
[quoted text clipped - 9 lines]
>
> Thank you for your assistance in advance.