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

Options
✭✭✭✭✭

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!

Tags:

• ✭✭✭✭✭
Options

Give this a try

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭
Options

Give this a try

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭
Options

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!

• ✭✭✭✭✭
Options

@Tina Rustvold Happy to help!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!