sorry i dont know how to explain this, so i had to do it with a pic, as you can see in the table under upgrade there are 3 values and 2 of them are attributed to ''darren'', while the other one is attributed to ''salesrep 2''

in the part individual sales / salesrep

it is attributing 3 to darren and 1 to salesrep 2, i am trying to use the countif feature, but it it not working, but count works,

the formula i have been using is =COUNT($K$7:$K$11,$A$7:$A$11,A19)

please help me with this, as it is doing my head in

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.

Thank you, it worked :)

Thanks for the feedback.