Help with Sum(if or SUMIFS

[arangoa79]

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.

I'm on 2007

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

[zbor]

This maybe?

=SUMIFS(C:C, A:A, ">"&A18-365, A:A, "<"&B19-365)

[arangoa79]

That worked thank you so much. Now another question the reason I use the -365 is because I want to turn, lets say 1/15/2009 in to 1/15/2008. The problem with using -365 is that I end up with 1/16/2008. Is there a way to calculate a current date to the exact date in an earlier year? Make sense?

[day92]

Im not sure I follow the logic in Column E. Where does the 112 come from in E19?

None the less - try this formula..

=SUM(IF(A:A>B17-365,IF(A:A<B18,C17,"")))

[zbor]

First, I made mistake putting A18 instead of B18...

For second question look this:

=SUMIFS(C:C,A:A, ">"&DATE(YEAR(B18)-1,MONTH(B18),DAY(B18)),A:A, "<"&DATE(YEAR(B19)-1,MONTH(B19),DAY(B19)))

[arangoa79]

Excellent, that worked. Great forum, thank you.