Countifs using iferror or iserror

Tiffany White
Tiffany White ✭✭✭
edited 12/09/19 in Formulas and Functions


I'm trying to use a COUNTIFS formula to count the number of VLOOKUP errors in another sheet that occur in the past month. From what I can see in other discussions the IFERROR and ISERROR functions are generally used to give a 0 value but I want it to return a value of 1 for each error. This is the formula I've been trying and I keep getting a total of 0 but I manually counted the errors and there were 15. I'm sure it's something silly that I'm missing and I would really appreciate any help or advise on how to get this to work.

=COUNTIFS({Weekly Report Range 1}, 1, {Weekly Report Range 2}, IFERROR({Weekly Report Range 2}, 1))

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!