OR in SUMIF function
Hello,
I am trying to use OR in SUMIF function as below but get invalid operation error:
=SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, [Column2]81, {Confidence Level}, [Column11]83) + SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, [Column2]81, {Confidence Level}, [Column11]84)
Answers
-
Sorry, below if the formula I use:
=SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, OR(({Confidence Level} = [Column11]84), ({Confidence Level} = [Column11]84)))
-
I am seeing a lot of different row numbers scattered throughout the formulas.
In your first formula you have
82
81
83
82
81
84
And in your second you have
82
84
81
Each across different columns. Can you verify that these formulas are referencing different rows?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!