Quote:
Originally Posted by darren1983
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.