IFERROR Statement with COUNTIFS, AND, OR.

Tim Wing

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.

Paul Newcome

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.

Paul Newcome

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)

Tim Wing

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.

Paul Newcome

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.