SUMIFS with multiple columns for current week

Hello everyone. First time posting. Actually first day being a member.

This might have been asked before. Point me in the right direction if so. I have a spreadsheet that we keep track of one of our employees vacation, overtime and attendance. I attached the file. I am trying to track overtime for both current week and last week. The current week overtime is in cell N5 and previous week is in cell N4. The formula in cell N5 works if I only do January. But when I try to include more than one month it gives an error. If the supervisor puts in "OT" in the code field, it will add it to the overtime. Am I over thinking this? Is there a better way?

Thanks.
Vince

Hi!

You could try:
[N5] =SUMIFS(D27:AV57,C27:AU57,"OT",B27:AT57,">="&N6,B27:AT57,"<"&N6+7)
Blessings!

Wow....Thanks guys. That was fast. I was hoping I had a hard one. I tried both of them. I guess I never realized you can select the whole area and still get what I need.

Thanks....Much appreciated.