Sum if week is the same - or blank if none

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!

Find more posts tagged with

Formulas

Accepted answers

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!

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.