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

Marv

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

Paul Newcome

You are going to need a SUMIFS:

https://help.smartsheet.com/function/sumifs

Paul Newcome

You are going to need a SUMIFS:

https://help.smartsheet.com/function/sumifs

Marv

Thanks for the input but I cannot get the sumifs formula to work.

Paul Newcome

If you provide what you've got so far as well as any error message(s), I'd be happy to help troubleshoot.

Marv

OMG - I got it! I did not know there had to be a space before and after the + sign between Sumifs formulas. Thank you!!