I converting a formula from

=SUMIF('[2011 Consolidated Master Allocation.xls]PR Rates'!$N$5:$N$478,V99,'[2011 Consolidated Master Allocation.xls]PR Rates'!$P$5:$P$478)

Result = 506

to

=SUMPRODUCT(('[2011 Consolidated Master Allocation.xls]PR Rates'!$N$5:$N$1000=V99),'[2011 Consolidated Master Allocation.xls]PR Rates'!$P$5:$P$1000))

Result = 0

Can anyone help me identify why I am getting a zero on the above sum product formula?