Try it like this:

=IF(D1=0,"",SUMPRODUCT(--(A$1:A$5=A1),--(D$1:D$5<0),--(B1B$1:B$5))+1)

Biff

wrote in message
ups.com...
Ok I thought I'd worked this all out but I tried to add another
condtion in as such:


=SUMPRODUCT(--(A$1:A$5=A1),,--(d$1:d$5<0),--(B1B$1:B$5))+1

where D would be filled with either 0,-1,1 and I want to limit my
ranking to those that have either 1 or -1 in D?
This still returns values for those with d values =zero?