SUM IF with OR Criteria throwing Invalid Operation error-what are we missing?

Tina Rustvold

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

Dan W

Give this a try

=SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, "JG", status:status, OR(@cell = "Mandatory", @cell = "Leader"))

Razetto

Have you tried using @ cell? I wonder if splitting the formula helps out:

=SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, @cell = "JG", Status:Status, @cell = "Mandatory") + SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, @cell = "JG", Status:Status, @cell = "Leader")

Dan W

Give this a try

=SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, "JG", status:status, OR(@cell = "Mandatory", @cell = "Leader"))

Razetto

Have you tried using @ cell? I wonder if splitting the formula helps out:

=SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, @cell = "JG", Status:Status, @cell = "Mandatory") + SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, @cell = "JG", Status:Status, @cell = "Leader")

Tina Rustvold

Thank you @Razetto and @Dan W! The @cell was the answer! So many things to remember it's great to have other brains to utilize. 😄 Have a great day!

Dan W

@Tina Rustvold Happy to help!