COUNTIFS Function

Hello everyone,

Need some help with this formula, thinking i have too much going on here?

=COUNTIFS({Environmental Incident Tracking Range 1}, AND({Environmental Incident Tracking Range 3} = 1, YEAR({Environmental Incident Tracking Range 4} = 2020, {Environmental Incident Tracking Range 1}, "Leak")))


Environmental Incident Tracking is the sheet I am trying to pull from.


Basically, for every quarter, I am looking for the total number of leaks reported, for the year 2020

TIA!

«13

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!