About Us

darren1983

Quote:

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.

Thank you, it worked :)

wickedchew

Quote:

Originally Posted by darren1983

Thank you, it worked :)

Thanks for the feedback.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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