Try this array formula:
=SUM(IF(A1:A10=F1,IF(C1:C10<"",IF(D1:D10<"",1,0) ,0),0))
then press Ctrl+Shift+Enter
Change the ranges as needed, F1 holds the search value

HTH

Die_Another_Day
jimswinder wrote:
I am having a difficult time finding anyone who can answer this question for
me.

A B C D
1 7/17/2006 06.123.456 224
2 7/17/2006 06.123.457
3 7/17/2006 06.123.458
4 7/17/2006 06.123.459 34
5 7/17/2006 06.123.460
6 7/17/2006 06.123.461
7 7/17/2006 06.123.462 32
8 7/17/2006 06.123.463 32
9 7/18/2006 06.123.464
10 7/19/2006 06.123.465
11 7/20/2006 06.123.466 32
12 7/21/2006 06.123.467
13 7/22/2006 06.123.468

Basically I need a formula to do the following: When Column "A" (Date)
equals a certain date (i.e.: 7/17/06), then look at corresponding columns in
that row where Column "C" (.06.123.456) and Column "D" (224). If they both
have a value (TRUE), then it has a value of (1), then sum all the instances
where it is true. In the example above, for 7/17/06 the answer would be 4.
The closestr thing I got wa the following function:

=SUMPRODUCT(--('Service Request Log'!$B$4:$B$5000=$A205)*('Service Request
Log'!$C$4:$C$5000<"0"))+SUMPRODUCT(--('Service Request
Log'!$B$4:$B$5000=$A205)*('Service Request Log'!$O$4:$O$5000)<0)

But it is summing the two columns ( "C" & "D" in the example) together so I
get a value of "12".

Thanks for any help someone might be able to give me.