Trying to count cells in between 2 values

[bizpioneer]

For example I want to count the number of "Y" in between cells with "X" highlighted some examples below:

So basically I need to count "Y" only if there are cells with "X" before and after. Not sure if that is even possible in excel?

You guys are the best, thanks

 

[AlphaFrog]

Confirm with Ctrl+Shift+Enter

=IF(COUNTIF(A1:L1,"x")<2,"",SMALL(IF(A1:L1="x",{0,1,2,3,4,5,6,7,8,9,1,11},""),2)-MATCH("x",A1:L1,0))

 

[bizpioneer]

Thanks, its works for some, but in the example below I get -1. while it should return 3

 

[bizpioneer]

wait i think there was a typo {0,1,2,3,4,5,6,7,8,9,1,11} so 1 should be 10 right before 11.. Thanks man it works perfectly now

 

[AlphaFrog]

Good catch. You're welcome.