How to use SUMIFS

Micaela Passetti

Hi Community!

I need to track the hours I spend on different tasks in a week.

Then, I need to sum the column "hours" if "date" is inside a specific period of time and if "done" is checked.

I tried the following formula, what should I correct? Thank you so much!

=SUMIFS(hours1:hours4, Date1:Date4, {Date Range}>= DATE(2023, 1, 01) <= DATE(2023, 1, 07), DONE1:DONE4, 1)

Find more posts tagged with

Accepted answers

Mike TV

@Micaela Passetti

=SUMIFS(hours1:hours4, Date1:Date4, >= DATE(2023, 1, 01), Date1:Date4, <= DATE(2023, 1, 07), DONE1:DONE4, 1)

If you add more rows it won't work because you're specifying partial amounts of the column to check.

All comments

Mike TV

@Micaela Passetti

=SUMIFS(hours1:hours4, Date1:Date4, >= DATE(2023, 1, 01), Date1:Date4, <= DATE(2023, 1, 07), DONE1:DONE4, 1)

If you add more rows it won't work because you're specifying partial amounts of the column to check.

Micaela Passetti

Thank you so much! It worked

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.