Assuming your dates are in column A and the amounts you want to sum
are in column B, then put the start date of your range in, say, F1 and
the end date in G1 and use this:

=SUMPRODUCT((A1:A100=F1)*(A1:A100<=G1),B1:B100)

This treats the dates in F1 and G1 as inclusive.

Hope this helps.

Pete

On Jan 13, 11:37*am, Vicki Leibowitz
wrote:
I have dates in 1 column and total amount (income) in another column.
I need the total amounts say from 1 Jan 10 to 8 Jan 10.
Logically: I want the sum total of income between 2 dates.
I've been trying to figure this out for days.