Counting Dates..is it possible?

I'm working on a health project and I want to count the number of people who
completed their Baseline paperwork, but did not get randomized into a
treatment group because they dropped out of the study.

I want to refer to Baseline Date (Date) and Randomized (Yes? No?)

If column D2:D999 (Baseline Date) have a date in the cell, then count it.
PLUS
If column E2:E999 (Randomized) is "No" then count it.

I tried
=SUM((COUNTIF(Enrollment!D2:D499,"(DATE)")))+(COUNTIF(Enrollment!E2:E499,"No")) but this formulas is counting anything in D2:D499

I do not want to use count blanks because then things that aren't entered
yet will get counted. This is a that will continute to grow.

Is this possible? If not, please let me know.

How about changing the formula to COUNTIF(Enrollment!D2:D999,">01/01/1900")
or some such date as required?

"ResearcherGirl" wrote:

> I'm working on a health project and I want to count the number of people who
> completed their Baseline paperwork, but did not get randomized into a
> treatment group because they dropped out of the study.
>
> I want to refer to Baseline Date (Date) and Randomized (Yes? No?)
>
> If column D2:D999 (Baseline Date) have a date in the cell, then count it.
> PLUS
> If column E2:E999 (Randomized) is "No" then count it.
>
> I tried
> =SUM((COUNTIF(Enrollment!D2:D499,"(DATE)")))+(COUNTIF(Enrollment!E2:E499,"No")) but this formulas is counting anything in D2:D499
>
> I do not want to use count blanks because then things that aren't entered
> yet will get counted. This is a that will continute to grow.
>
> Is this possible? If not, please let me know.

=SUMPRODUCT(--(Enrollment!D2:D499<>""),--(Enrollment!E2:E499="No"))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ResearcherGirl" <[email protected]> wrote in message
news:[email protected]...
> I'm working on a health project and I want to count the number of people
who
> completed their Baseline paperwork, but did not get randomized into a
> treatment group because they dropped out of the study.
>
> I want to refer to Baseline Date (Date) and Randomized (Yes? No?)
>
> If column D2:D999 (Baseline Date) have a date in the cell, then count it.
> PLUS
> If column E2:E999 (Randomized) is "No" then count it.
>
> I tried
>
=SUM((COUNTIF(Enrollment!D2:D499,"(DATE)")))+(COUNTIF(Enrollment!E2:E499,"No
")) but this formulas is counting anything in D2:D499
>
> I do not want to use count blanks because then things that aren't entered
> yet will get counted. This is a that will continute to grow.
>
> Is this possible? If not, please let me know.