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.
Help Article Resources
Categories
Check out the Formula Handbook template!