Excel 2007 : SUM(IF or SUMIFS

OK, so this is my problem. I need to be able to add up the values in column C if the values in column A meet two criteria which are driven by values in column B. Below is one formula I was trying to use but I get an #VALUE!. Column E has the actual result that I’m hoping to get from the formula. Any ideas on how to do this? File is attached.

{=SUM(IF(AND(A:A>B17-365,A:A<B18-365),C:C,"-"))}

X-post.

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this