Formula for counting the number of times Incident OR Near Misses are reported in a Year



I am trying to write a formula for counting the number of times we have incidents OR near misses reported in a year.

The formula =COUNTIFS({Aviation Safety Reports Range 1}, =2020, {Aviation Safety Reports Range 2}, "Incident") is working for counting just incidents, but when I try to add an OR "Near Miss" on, it doesn't work.

All help greatly appreciated


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!