Let's go the whole hog !! Put 1, 2, 3 for the Phases in cells M1:M3
(say), and in N1 put this formula:

=SUMPRODUCT((E$1:E$100=M1)*(D$1:D$100<TODAY())*(D$ 1:D$100<""))

I've assumed you have 100 rows of data, so increase this if you have
more. This will give you a count of the number of rows for phase 1
with an effective date less than today. Copy the formula into N2 and
N3 to get a count for phase 2 and phase 3 respectively.

Hope this helps.

Pete

On Apr 10, 4:06*pm, Lauren wrote:
I need help with a complicated conditional formula. Here is what I want
written out. I do not know how to translate that into an Excel formula. The
data is copied below.

IF column E "Phase" is equal to 1, AND there is data (an effective date less
than today's date) in column D "Effective Date" THEN I want Excel to COUNT
that.

I will also need to count Phases 2 and 3 as well, but let's just start with
Phase 1!!

I hope you can help me!!

I am using Excel 2003

Here is a portion of the data:

Effective Date *Phase
1-Jan-07 * * * * * * * * * * * *1
6-Aug-08 * * * * * * * * * * * *2
1-Jun-07 * * * * * * * * * * * *3
1-Jun-07 * * * * * * * * * * * *3
17-Aug-07 * * * * * * * * * * * 2
1-Jun-07 * * * * * * * * * * * *2
15-Jun-07 * * * * * * * * * * * 2
1-Jun-07 * * * * * * * * * * * *2
1-Sep-06 * * * * * * * * * * * *1