Counting Dates..is it possible?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=SUMPRODUCT(--(Enrollment!D2:D499<>""),--(Enrollment!E2:E499="No"))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

ResearcherGirl said:
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
Click to expand...
=SUM((COUNTIF(Enrollment!D2:D499,"(DATE)")))+(COUNTIF(Enrollment!E2:E499,"No
")) but this formulas is counting anything in D2:D499
 
Back
Top