Equation help

Hi all, I'm not very privy with formulas, but am attempting to learn. I'm working on keeping track of square footage production based on "in progress" or "completed" in a manufacturing setting. There are 6 different steps to each unit produced (on different lines, see screen shot), and I'm trying to figure out a way to calculate the totals of each specific step. I'm assuming SUMIFS would be the correct route, but any help would be useful. In the past I would individually pick each cell for a =SUM(, but I've learned there's a limit of 200 or so.

I'm hoping to avoid having to do this again

Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!