SUM from another sheet based on the week

Alicia L

I have a reference sheet that each row could be a different day. I need the sheet I'm working on to sum the number of findings based on the week. Here is the reference sheet (there are many more dates not shown in the screen shot)

Here is the sheet I need to sum the findings. The formula I attempted is in the screenshot.

Hudson_Miller

@Alicia L

I created data to try and help you dial in your formula. I called one sheet "Source Data" and a second set Summary Sheet. The formula lives on the summary sheet in the # of findings column.

You will note that I have a "Week Ending" column. This was used while constructing the formula to make sure I was capturing the right data in testing. It is not used in the final formula.

Something like this:

=SUMIFS({Source Data | Findings}, {Source Data | Date}, {Source Data | Date} >= [Week Start]@row, {Source Data | Date}, {Source Data | Date} <= ([Week Start]@row + 6))

Best,

Hudson

Hudson_Miller

@Alicia L

I created data to try and help you dial in your formula. I called one sheet "Source Data" and a second set Summary Sheet. The formula lives on the summary sheet in the # of findings column.

You will note that I have a "Week Ending" column. This was used while constructing the formula to make sure I was capturing the right data in testing. It is not used in the final formula.

Something like this:

=SUMIFS({Source Data | Findings}, {Source Data | Date}, {Source Data | Date} >= [Week Start]@row, {Source Data | Date}, {Source Data | Date} <= ([Week Start]@row + 6))

Best,

Hudson