COUNTIF formula counting specific criteria under a PARENT row

Hi All,

I have a shipping tracker I created for six different stages we're doing for a project. I need to create a graphical representation of the different statuses for each stage and type. The formula would read: Count of "delivered" for "POM to IHA" under "WW01, as one example. A separate formula would be Count of "In Transit" for "IHA to PA" under WW02. I've attached a picture of my table to show you what I'm referring to.





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!