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

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓

    Move your OR function to after the Type:Type range reference, and drop the last parentheses:

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

    Regards,

    Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!