=SUMPRODUCT((INT($C$8:$C$100)=C1)+0,(INT($C$8:$C$ 100)<=C2)+0,$J$8:$J$200)

Scott Frickman wrote:
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



--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.