SUMIF multi-condition syntax

a Coworker and I have been banging our heads on this one for a couple weeks now for a project under development.

We're trying to SUM hours {TotalTime} within a date range that meets a label criteria (@cell, Month16). It actually works until I add the AND condition. Below is my #INCORRECT AURGUMENT SET

=SUMIF({Activity}, HAS(@cell, Month16), {Date}, AND(@cell >= DATE(2022, 1, 1), @cell <= DATE(2022, 1, 31), {TotalTime}))

Any ideas?

Find more posts tagged with

Formulas

Conditional Formatting

Accepted answers

All comments

Paul Newcome

To have multiple range/criteria sets, you need to use a SUMIFS (with the "S" on the end). Keep in mind that the function does have a different syntax from the SUMIF function.

You also have a misplaced parenthesis. One of them on the end should be moved to immediately after the second date function closing so that you close off the AND function before moving on to the next portion of the SUMIF/S.

MikeLowry

I was afraid you were going to say that 😂

Thank you @Paul Newcome , I'll have at it

Paul Newcome

It should end up looking like this:

=SUMIFS({Total Time}, {Activity}, HAS(@cell, Month16), {Date}, AND(@cell >= DATE(2022, 1, 1), @cell <= DATE(2022, 1, 31)))

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.