Count Children in adjacent column

How do you write a formula to count certain values of an adjacent column from where you want to the count value displayed.  In my sheet I need to count open positions and filled positions based on the status.  My sheet is very large so I have to replicate this many times with varying row #s so looking for a quick way to tell the sheet to count the values of children rows in the status column.  

Thanks in advance! 

SS Staff Patterns Columns.JPG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!