Sumproduct with date range?

Hi Guys/ Girls,

I was looking on some other posts, but couldn't find what I needed.


I need a sumproduct ? function that will give me the total amount of july revenue (column L) when the date range (column K) is between july 1st and the 31st?
[c]
COLUMN K COLUMN L COLUMN M
Resolution Date Create Date Revenue Amount
10/7/08 25-Jun-08 0
10/7/08 25-Jun-08 0
10/16/08 27-Jun-08 0
10/16/08 30-Jun-08 0
10/1/08 1-Jul-08 2832
10/3/08 1-Jul-08 12740.07
10/31/08 1-Jul-08 63253.34
10/9/08 1-Jul-08 0
10/10/08 7-Jul-08 0
[/c]


thank you soooo much!!

Thank you sooo much!!!

I was wondering if you could help me throw a few more variables in the equation?




I need a sumproduct ? function that will give me the total amount of july revenue (column L) when the date range (column K) is between july 1st and the 31st?

In addition to the criteria above, I also want to only include any revenue amount that is coded as "cust" in (column d) and "n" in (column f)

Thanks again!!

thx for all of your help!