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

Tags:

Best Answers

  • Dan W
    Dan W ✭✭✭✭✭
    Answer ✓

    Give this a try


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

  • Razetto
    Razetto ✭✭✭✭✭✭
    Answer ✓

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!