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