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)")))+(COUN TIF(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.

Counting Dates..is it possible?
 

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)")))+(COUN TIF(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.

Counting Dates..is it possible?
 

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ResearcherGirl" wrote in message
...
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)")))+(COUN TIF(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.