Not sure if this would be a formula, but I'm looking to count how many "X" cells are found starting at column A before you reach a cell that equals "B".
Row 9: 3
Row 12: 4
Row 15: 5
Any leads would be appreciated. :eeek: