Try this:

=SUMPRODUCT(--(F1:F10=DATE(2007,1,1)),--(L1:L10="X"))

Or, use cells to hold the criteria:

A1 = some date like 1/1/2007
B1 = X

=SUMPRODUCT(--(F1:F10=A1),--(L1:L10=B1))

Biff

"mbparks" wrote in message
...
I am trying to get a count of rows where the date column has a specific
date
and a second column is marked with an "X".
Example:
Col F is a column of dates
Col L is marked with an "X" by the end user if certain events have taken
place.

Please help.