Between dates
 

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.

Between dates
 

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.

Between dates
 

Hi,

Try this

=sumproduct((B2:B15=B18)*(B2:B15<=C18)*(C2:C15))

B18 has 1/1/2010 and C18 has 8/1/2010. B2:B15 has dates and C2:C15 has
amounts

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Vicki Leibowitz" wrote in
message ...
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.