Sum if week is the same - or blank if none

Angie Hatfield

Good afternoon,

I'm sorry for a somewhat redundant question but I've not been able to get this to work.

I need to sum up the hours if the days are in the same week. But, if no date, leave it blank.

I have a date column that could be used and a week of the month column.

This is one of many formulas I've tried.

=IF(COUNTIFS([Week of the Month]:[Week of the Month]@row, [Week of the Month]@row, SUMIFS([Hours Worked]:[Hours Worked]@row, [Week of the Month]:[Week of the Month@row, [Hours Worked]@row, ""))

I appreciate your expertise on this!

AKnight

Hi @Angie Hatfield !

Try

=SUMIFS([Hours Worked]:[Hours Worked], [Week of the Month]:[Week of the Month], [Week of the Month]@row)

AKnight

@Angie Hatfield I forgot that you wanted no date then leave blank, I tacked on an extra section from my comment above to account for that:

=SUMIFS([Hours Worked]:[Hours Worked], [Week of the Month]:[Week of the Month], [Week of the Month]@row, Date:Date, Date@row <> "")

Let me know if that works for you!

AKnight

Hi @Angie Hatfield !

Try

=SUMIFS([Hours Worked]:[Hours Worked], [Week of the Month]:[Week of the Month], [Week of the Month]@row)

AKnight

@Angie Hatfield I forgot that you wanted no date then leave blank, I tacked on an extra section from my comment above to account for that:

=SUMIFS([Hours Worked]:[Hours Worked], [Week of the Month]:[Week of the Month], [Week of the Month]@row, Date:Date, Date@row <> "")

Let me know if that works for you!

Angie Hatfield

@AKnight It worked perfectly and I see now how it should be.

I can't thank you enough. Thank you Thank you!