Originally Posted by wickedchew

You can use the SUMPRODUCT function for this.

Let's say your table is like this:

A B
1 Darren 5.32
2 Salesrep 2 1
3 Salesrep 3
4 Saleserp 4
5 darren 2.32

=SUMPRODUCT(--(A1:A5="Darren"),--(B1:B5<0))

Hope this helps.