Between dates

[Vicki Leibowitz]

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.

 

[Pete_UK]

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

 

[Ashish Mathur]

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