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?