SUMIFS referencing another sheet

I'm trying to get a SUM of a column, including only rows that meet specific conditions.

I want a SUM of "Launch Requests Range 2" if "launch requests range 1 includes the word "template" AND if Launch Request Range 3 is "52" AND if "launch requests range 4" (which is a date-type cell) is in the year 2024.

I've tried several variations and here's what I have now- I feel like I've only gotten farther from the correct solution with recent changes- I now have an "#UNPARSEABLE error

=SUMIFS({Launch Requests Range 2}, {Launch Requests Range 1}, CONTAINS("template", @cell), AND{Launch Requests Range 3}, ="52"@cell, AND {Launch Requests Range 4}, YEAR(@cell ) =2024)

Find more posts tagged with

Accepted answers

All comments

Jeremy_D

Hi @Rfitz, I believe you're adding in CONTAINS and AND where it is not needed. Try:

=SUMIFS({Launch Requests Range 2}, {Launch Requests Range 1}, "template", {Launch Requests Range 3}, 52, {Launch Requests Range 4}, YEAR(@cell)=2024)

Hope that helps :)

Rfitz

Thanks @Jeremy_D! Now I'm getting 0, so the formula is at least formatted correctly, but 0 is not the correct value. Does it need CONTAINS or something similar with the "template" reference because that cell can contain a long string of selections? "Template" is the unique word in the specific option I'm looking to reference.

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.