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


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!