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")))
Best Answers
-
Give this a try
=SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, "JG", status:status, OR(@cell = "Mandatory", @cell = "Leader"))
-
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
-
Give this a try
=SUMIFS([Current Hours Per Month]:[Current Hours Per Month], Leader:Leader, "JG", status:status, OR(@cell = "Mandatory", @cell = "Leader"))
-
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 Happy to help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 151 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!