SUMIFS referencing another sheet

Rfitz

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)

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.