Sumproduct and Counta function

Ok I've been messing with this the last 2 nights and just can't figure it out. I'm trying to use a sumproduct function with also referencing a specific cell value. Here is the formula which works

Cell B2->MedZone Efficiency
=SUMPRODUCT(($A$2:$A$417="Y")*($D$2:$D$417=D2)*($F$2:$F$417))/E2

My goal is instead of typing in the 417 to be able to reference it. The cell I need to reference is located in cell B2 of a tab I have named as "Counts". If possible I'd love to do the same with my vlookup formula

Cell C2->Minimums
=VLOOKUP($D$2:$D$417,Efficiency_Query_Part_2!$A$2:$H$210,7,FALSE)

The cell I'd like to reference instead of typing 210 would be cell B3 of a tab I have named as "Counts"

I have attached the spreadsheet, any help would be much appriciated!