try
=sumproduct((c8:c200c1)*(j8:j200<c2)*n8:n200)

--
Don Guillett
SalesAid Software

"Scott Frickman" wrote in message
...
In col C8:C200 I have start dates entered by date and time. In col
J8:J200
I have end dates entered by date and time. In col N8:N200 I have values
for
each transcation.

What I would like to do is in cell C1 enter a start date. In cell C2
enter
a end date. In cell C3 have a formula that based on C1 and C2 find the
dates that are equal to, or between the start and end dates and based on
those match sum the values in col N