SUMIFS with Multiple Criteria and OR function

t.fleischman

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!

Jeff Reisman

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"))

Jeff Reisman

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"))

t.fleischman

It worked! I tried many hours moving the formula all around. lol Thank you!

Jeff Reisman

https://community.smartsheet.com/discussion/comment/315069#Comment_315069

Glad I could help!