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
-
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
-
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!
-
It worked! I tried many hours moving the formula all around. lol Thank you!
-
Glad I could help!
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!
Help Article Resources
Categories
Check out the Formula Handbook template!