Counting Cells that come before and after a cell with specific text

[camelrunner]

I'm working in macro-enabled workbook. The tab I'm working on "Direct" has data appearing from user input on the tab "Input". The user chooses the data on the Input tab to send to the Direct tab as an A or B. The data is then grouped with all the A selections and then all the B selections with the header cells containing "Data A Selection" and "Data B Selection" above the data. I need to count how many cells are between the A selection and the B selection. Additionally I then need to count the number of cells after the B selection header. Each data entry in the A and B selection are separated by a blank row, so I'm think I need the TRIM function. The issue I'm having is I can't search within in a fixed range because the number of A and B selections change based on the number of data values, so 1 user may have 5 A selections and 2 B selections and another user may have 1 A selection and 5 B selection.

 

[Scott Huish]

Can you post some sample data and expected results?

 

[camelrunner]

Input from User 1

Input from user 2

Route A will always start in A9 in the workbook, but Route B varies based on how many data samples are under Route A. I need to count how many data samples (#1-1, #1-2, #2-1, etc) are underneath Route A and Route B so I can have a cell off to the side that shows the total for Route A and another cell that shows the total for Route B. For User one the total would be Route A: 7 and Route B:2, User 2 would have Route A: 3 and Route B:1.