Sum If dates are between week of

[Wskip49]

I'm not sure where to start. I tried =And(>=dates(7/6/15),<=dates(7/11/15),Sum(Form Responses1(B2:B4)) but that did not work at all. What I'm trying to do is sum only the dates that fall between week of sheet. I have 52 week of and need to transfer and sum how many occurrences fall between each one. I hope this is clear.

[6StringJazzer]

What are you trying to sum? Responders sent? Contact hours? Students served?

You need to use SUMIFS. You can use this formula in Sheet "Week Of" to sum the number of Responders Sent in "Form Responses 1" (column W) for each range of dates. Put in C1 and copy down.

Please Login or Register  to view this content.

[Wskip49]

Thanks, I reversed the ">="&$v1 to "<="&$v1 and it work great.

[Wskip49]

Thanks that worked great. I reversed the last part to say less than or equal to. i am also trying to make the numbers go to the correct spot. Can another function working with the one above? In the Form Responses 1 sheet in column X are code number that correspond with the codes on the Week Of sheet. How can I get the Responses to go to the correct code number on Week Of Sheet?

[Wskip49]

Can another function work with this one? See Last Post.

[FDibbins]

Try this in C4, copied across and down...
=SUMIFS('Form Responses 1'!$W:$W,'Form Responses 1'!$B:$B,">="&$U4,'Form Responses 1'!$B:$B,"<="&$V4,'Form Responses 1'!$X:$X,'Week Of'!C$3)

[Wskip49]

FDibbins your solution worked perfectly. Thank you so much.

[FDibbins]

Happy to help and thanks for the feedback (Jeff did all the heaving-lifting on this 1)