Because you want to count "J" in the odd rows where the even rows immediately above them contain "Q".
$K$5:$K$347,"J" - odd rows (5, 7, 9, etc.)
$K$4:$K$346,"Q" - even rows (4, 6, 8, etc.)
Excel 2016 (Windows) 32 bit
H I J 5 All Even Odd 6 Q Q 7 J J 8 Q Q 9 J J 10 Q Q 11 J J 12 Q Q 13 X X 14 Y Y 15 J J
Sheet: Records (2)
Bookmarks