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.

Ben Bahr

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.

KPH

Hi

It looks like you may be using excel. There is not an ISERR function in smartsheet. The formulas suggested here are for smartsheet.