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

Options

Hi,

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

Rachael

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!