First time actually posting an issue on here so thank you in advance for the help. What I have been wracking my brain on lately is the following:

I have a worksheet that has the following data: Community name, Date, and Water Usage for that day.

On a separate worksheet I have a row for each community to calculate their monthly accrual. What I am looking for is a formula that will return the Max usage between a specific date range (say 4/1/2012 and 5/1/2012) for a specific community. Thanks for any help I get and if there are any questions let me know.

Thanks!