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!!