I am trying to replace the formula listed below with SUMPRODUCT:

=SUMIF('M:\M Inc\F2007\Revenue, Volume and Expenses By Client
\Calculation Templates\[TD F2007 January Revenue and Volume
Statistics.xls]Sheet1'!$E$164:$E$171,$A8,'M:\M Inc\F2007\Revenue,
Volume and Expenses By Client\Calculation Templates\[TD F2007 January
Revenue and Volume Statistics.xls]Sheet1'!$F$164:$F$171)+SUMIF('M:\M
Inc\F2007\Revenue, Volume and Expenses By Client\Calculation Templates\
[TD F2007 January Revenue and Volume Statistics.xls]Sheet1'!$E$130:$E
$156,$A8,'M:\M Inc\F2007\Revenue, Volume and Expenses By Client
\Calculation Templates\[TD F2007 January Revenue and Volume
Statistics.xls]Sheet1'!$F$130:$F$156)

Replacing the sumif with =SUMPRODUCT(- gives me th #value error.

Thanks in advance for your assitance.