Dynamic Formula Extract Data for multiple criteria

Basing my formula via this video:

http://www.youtube.com/watch?v=NbP-dHau9-I

Pretty powerful tool. I have setup the initial SUMPRODUCT, with some help from this forum.

I am setting up a translation exists formula and am running into issues. I am SUMPRODUCT to get the overall count that follows the two breakdown areas:

1) no translations but installation exists
2) translations exist but no installations exist

The formula I have created to make this dynamic, as items change the list will change, is below:

FORMULA #1 for No Translations, installations exist

=IF(ROWS(A$10:A10)=$D$4,INDEX(INDIRECT($A$9),SMALL(IF(Instructions_for_Use_Instruments___Reagents_for_professional_use=$C$4,IF(IFU_Instrument___Reagents_Translation_Exists=$B$4,ROW(IFU_Instrument___Reagents_Translation_Exists)-ROW(Sheet1!$E$2)+1)),ROWS(A$10:A10))),"")

FORMULA #2 for Translations, no installations exist

ROWS(D$10:D20)=$D$3,INDEX(INDIRECT($D$9),SMALL(IF(Instructions_for_Use_Instruments___Reagents_for_professional_use<>$C$3,IF(IFU_Instrument___Reagents_Translation_Exists>$B$3,ROW(IFU_Instrument___Reagents_Translation_Exists)-ROW(Sheet1!$E$2)+1)),ROWS(D$10:D20))),"")

Right now the formula is pushing back a #REF, and I am unsure why. It might be because part of this formula is trying to pull in information that is not a number but text. However, as you can see the second formula shows blanks for the "11" items that do exist, but then the REF appears in the 11th line, so I know I am close on this one.

Any help working through this would be helpful. thanks!