Special count

[RIC63]

Moorning,

I am working with excel 2021 and 2024

With reference to the attached file

I would like in row 6 the count of how many values ​​are found in each column - starting from the top and searching downwards - before encountering one of the values ​​in range A2÷E2 and in row 7 the count of how many values ​​are found in each column - starting from the bottom 'always from row 22' and searching upwards - before encountering one of the values ​​in range A2÷E2 ...I manually entered the expected values

I tried to find examples with count.if but I am not able to build a valid macro, if anyone has a suggestion

thanks in advance