Formula Help- Calculating Costs

Hello,

So i have this formula: =COUNTIFS({Environmental Incident Tracking Range 3}, "1", {Environmental Incident Tracking Range 7}, =(2020), {Environmental Incident Tracking Range 5}, "R507", {Environmental Incident Tracking Range 1}, "Leak / Fuite")

But i need it to match this criteria, but calculate the cost accumulated from R507 Leaks.

Cost is in Range 8, called "cost of refrigerant"


TIA

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!