Count non-#N/A values in an INDEX/MATCH array

I am trying to come up with a much shorter way to do the following:

=COUNT(INDEX(AandH!$B$3:$S$13,MATCH($A5,AandH!$B$3:$B$13,0),11):INDEX(AandH!$B$3:$S$13,MATCH($A5,AandH!$B$3:$B$13,0),18))

in which I need to locate a cell value ($A5 on worksheet Analysis!) on another worksheet (AandH! in my example) and then count the number of cells in a specific array (11-18 in the example - which, if useful, is worksheet AandH columns L through S) that don't have a #N/A value. The formula will need to be duplicated up to eleven times in a single SUM formula in order to give a total count on multiple worksheets so my current formula is far too long.

Any ideas?

If I've got this right, I think you need:

=COUNT(INDEX(AandH!$L$3:$S$13,MATCH($A5,AandH!$B$3:$B$13,0),0))

Thanks, Cutter! It looks like you understood exactly and it works beautifully with a formula half the length. You've solved my problem!

Again, Thanks!

You're welcome. Glad I could help.