How can I convert this sumif statement into a Sumproduct?

You wouldn't normally have a range like V9:V109 as the criteria in a SUMIF formula, is this a formula you copy down? If so the just use V9 and as you copy down that will change accordingly. Given that the SUMPRODUCT equivalent would be as follows:

=IF(A10=1,SUMPRODUCT(('[2011 Consolidated Master Allocation.xls]PR Rates'!$K$5:$K$156=EE10),'[2011 Consolidated Master Allocation.xls]PR Rates'!$I$5:$I$156),SUMPRODUCT(('[2011 Consolidated Master Allocation.xls]PR Rates'!$A$5:$A$478=V9),'[2011 Consolidated Master Allocation.xls]PR Rates'!$C$5:$C$478))