I am trying to figure out how to sum a cell based on another cells criteria.

So below is my data and I need a cost total for each items condition - 1 - Critical Item, 2 - Urgent Item and 3 - Preventive item by unit number.

EX: how much will it cost to repair all 1 -Critical Items for unit 1

Each row in my sheet contains 15+ items, conditions and cost

Any help would be appreciated


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!