SUMIFS on columns


I'm looking to sum the values in the duration column, if the row is not marked as a bug (this is a checkbox column) and if the district name matches a value (in this case Muskogee).

This is what I've come up with and it's not working:

=SUMIFS(Duration:Duration, [District Name]:[District Name], "Muskogee", [Program Bug/No Charge]:[Program Bug/No Charge], "0")

Help :(


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!