Sumif Issue Multiple Criteria

Hello,

I am trying to sum the number in the Count column (Range 6) if the solution = RC WHS (Range 4) and if the 1st Inbound in the 2nd quarter of 2023 (Range 5).

This is not working.

=SUMIFS({1. Task Sheet Range 6}, {1. Task Sheet Range 4}, "RC WHS", {1. Task Sheet Range 5}, "1st Inbound", {1. Task Sheet Range 5}, AND(@cell >= DATE(2023, 4, 1), @cell <= DATE(2023, 6, 30))))

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Is range 5 the [Date] column from your screenshot?

jlee579

Range 5 is Client1 where 1st Inbound is held.

Paul Newcome

It looks like you are also evaluating it for your date criteria as well then. Try creating a new cross sheet reference looking at the date column to use for the date criteria.

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.