SUMIF FORMULA HELP

Options

I have the formula

=SUM({Tracker COST BENEFIT})

This totals the whole column of another sheet, I'd like to filter that total by counting only the items which are closed.

I've tried

=SUMIFS({Tracker COST BENEFIT}, ({Tracker STATUS}, "closed"))

But this doesn't seem to work Anyone have any ideas?

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!