Index Match to Skip/Ignore Blanks in Row

OK. GOOD....

So, set up 2 Named Ranges (called START and END - what else???):

=INDEX(Sheet2!$1:$1048576,11,MATCH($C8,Sheet2!$9:$9,0)+1):INDEX(Sheet2!$1:$1048576,39,MATCH($C8,Sheet2!$9:$9,0)+1)

=INDEX(Sheet2!$1:$1048576,11,MATCH($C8,Sheet2!$9:$9,0)+2):INDEX(Sheet2!$1:$1048576,39,MATCH($C8,Sheet2!$9:$9,0)+2)


CTRL-F3 to view/edit them.


Then use this in D8 copied across and down:

=SUMPRODUCT((Start<=D$3)*(End>=D$3))