software

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 D2999 (Baseline Date) have a date in the cell, then count it.
PLUS
If column E2:E999 (Randomized) is quot;Noquot; then count it.

I tried
=SUM((COUNTIF(Enrollment!D2499,quot;(DATE)quot;))) (COUN TIF(Enrollment!E2:E499,quot;Noquot;)) but this formulas is counting anything in D2499

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!D2999,quot;gt;01/01/1900quot;)
or some such date as required?

quot;ResearcherGirlquot; wrote:

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

=SUMPRODUCT(--(Enrollment!D2499lt;gt;quot;quot;),--(Enrollment!E2:E499=quot;Noquot;))--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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