Between dates

V

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.
 
P

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top