SUMIFS with OR (Sheet Summary)
I'm trying to create a sheet summary formula
Sum up a Column -Total Save
If
Status column is "Orange"
And
Hierarchy Level 4 - SubDivision is "Solutions"
And either
FY23 into FY22 Pull Frwd (TM Notify) box is checked
or
Addition to Pull Frwd box is checked
=SUMIFS([Total Save]:[Total Save], OR([FY23 into FY22 Pull Frwd (TM Notify)] = 1, [Addition to Pull Frwd (TM Notify)] = 1), Status:Status, "Orange", [Hierarchy Level 4 - SubDivison]:[Hierarchy Level 4 - SubDivison], "Solutions"))
I keep getting unparseable result. Does is have to do with the fact that I'm in "sheet summary"? I've tried is many different ways and now I'm stuck. Any help would be much appreciated. 😀
Best Answer
-
You are going to need to use a SUMIFS for each of the different checkbox columns and then add those SUMIFS together.
=SUMIFS([Sum Column]:[Sum Column], [1st Checkbox]:[1st Checkbox], @cell = 1) + SUMIFS([Sum Column]:[Sum Column], [2nd Checkbox]:[2nd Checkbox], @cell = 1)
Answers
-
You are going to need to use a SUMIFS for each of the different checkbox columns and then add those SUMIFS together.
=SUMIFS([Sum Column]:[Sum Column], [1st Checkbox]:[1st Checkbox], @cell = 1) + SUMIFS([Sum Column]:[Sum Column], [2nd Checkbox]:[2nd Checkbox], @cell = 1)
-
That worked! 😀
I utilize your answers all the time and really appreciate it!
Thank you Paul!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!