About Us

wickedchew

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
with Excel 2007, f9 doesnt work. please help.	nihan tugcu	Excel Discussion (Misc queries)	1	January 5th 10 08:31 AM
when i type txt in excel doesnt work	excel worksheet functions to be active	Excel Worksheet Functions	0	October 18th 09 12:01 PM
Excel 2007 doesnt close	gb4	Excel Discussion (Misc queries)	2	April 10th 08 07:49 PM
In excel my bold command doesnt work?	Parvez Ansari	Excel Worksheet Functions	3	March 10th 05 10:47 PM
why doesnt excel open files when i click on them	whisker	Excel Discussion (Misc queries)	2	February 19th 05 12:35 PM

Menu

About Us