SUMIFS with Multiple Criteria and OR function

Hello,

I am trying to count the number of "sites" in Site Count that have a Projected Contract Sign Date in "Q1-2022" that are a Type of either a "Migration" or "Full Install". Can someone please review my formula below and advise? I am receiving #UNPARSEABLE error message.

=SUMIFS([Site Count]:[Site Count], [Projected Contract Sign Date]:[Projected Contract Sign Date], "Q1-2022", OR(Type:Type,(@cell = "Migration", @cell = "Full Install")))

Thank you!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!