SUMIFS with Multiple Criteria and OR function
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")))
Help Article Resources
Check out the Formula Handbook template!