Newer to Smartsheet, trying to build metrics around ranges of data

Options

Okay here is what is working for me:

What I really want to count is this:

as soon as I add in a range of criteria, it returns a sum of 0 - having trouble figuring out if there is a better way to write this out - the statuses are formatted exactly like this on my source sheet. Any help would be greatly appreciated.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!