SUM IF with OR Criteria throwing Invalid Operation error-what are we missing?
I am trying to count a number meeting hours for each leader, but only meetings they lead or are mandatory to attend. I have been trying to get this to work for those 2 types of 'status' and I must missing a nuance somewhere. Thanks!
=SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, "JG", (OR(Status:Status = "Mandatory", Status:Status = "Leader")))
Help Article Resources
Check out the Formula Handbook template!