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!
Help Article Resources
Check out the Formula Handbook template!