IFERROR Statement with COUNTIFS, AND, OR.
Hi Community.
I want to add an IFERROR statement to a formula on a Calculations Template sheet.
This one is fine: =IFERROR(COUNTIF({Status Range 1}, ="Submitted") + COUNTIF({Status Range 1}, ="Rejected - Further Detail required"), 0)
I am struggling to get it to work in this Calc: =COUNTIFS({Tracker Range 3}, "Red", {Status Range 1}, AND(OR(@cell = "Submitted", @cell = "Rejected - Further Detail required")))
Where should the statement fit in this formula. The formula itself without the IFERROR function works fine. Help gratefully received.
Best Answer
-
Yeah. You would just use the IFERROR the same way you did in your first formula, and you don't need the AND function at all. Just the OR statement.
Answers
-
If the base formula works fine (although I'm not sure how that AND/OR combo is supposed to be working), then you would add the IFERROR the same way you have it in your first formula.
=IFERROR(original_formula, 0)
-
Thanks Paul.
I may have over complicated my formula, but it seems to work. I am just saying when the 'Priority column (Tracker Range 3) is ragged Red, count how many rows in the 'Status' column (Status range 1) show as "Submitted" or "Rejected - Further Detail required" but also include the IF ERROR.
Please let me know if this can be simplified.
Thanks again.
-
Yeah. You would just use the IFERROR the same way you did in your first formula, and you don't need the AND function at all. Just the OR statement.
-
I used this comment thread to arrive at this formula:
=IF(ISERR(D11),"",COUNTIF($D$11:$D$310,">"&D11))
However, my rank set delivers the top ranked profile to 0 instead of 1. Wondering if there is something I have missed.
-
Hi
It looks like you may be using excel. There is not an ISERR function in smartsheet. The formulas suggested here are for smartsheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!