How do you write a SUMIFS forumula with 3 criteria?

Below is my formula, but I am not getting it right:

=SUMIFS({2020 OE Revenue Actual & Projected Range 1}, {2020 OE Revenue Actual & Projected Range 2}, "New Business", [({2020 OE Revenue Actual & Projected Range 3}, >12/31/19), ({2020 OE Revenue Actual & Projected Range 3}, < 02/01/20)])

Find more posts tagged with

Accepted answers

Paul Newcome

There are a few minor tweaks...

You do not need the square brackets, and when referencing a date in Smartsheet, you have to use the DATE function. There is also an extra set of parenthesis that isn't needed tucked in there.

DATE(yyyy,mm,dd)

=SUMIFS({2020 OE Revenue Actual & Projected Range 1}, {2020 OE Revenue Actual & Projected Range 2}, "New Business", {2020 OE Revenue Actual & Projected Range 3}, > DATE(2019, 12, 31), {2020 OE Revenue Actual & Projected Range 3}, < DATE(2020, 02, 01))

All comments

Paul Newcome

There are a few minor tweaks...

You do not need the square brackets, and when referencing a date in Smartsheet, you have to use the DATE function. There is also an extra set of parenthesis that isn't needed tucked in there.

DATE(yyyy,mm,dd)

Lisa Burgess

Your a genius! Thank you!!

Paul Newcome

Happy to help! 👍️

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.