Posted to microsoft.public.excel.worksheet.functions

wild turkey no9 wild turkey no9 is offline

external usenet poster

Posts: 20

SUMPRODUCT usage

Hi There

Is there an easy way to configure sumproduct to do the following:

multiply col A * Col B when col B = either E or N or D

Thanks

Kevin

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
About the usage of the function	Keith Hui	Excel Worksheet Functions	1	March 31st 09 04:12 PM
Sumproduct() usage	Jim May	Excel Discussion (Misc queries)	2	January 11th 08 09:55 PM
New Errors in Sumproduct Usage	Danger Mouse	Excel Worksheet Functions	5	April 12th 07 03:44 PM
limited usage	jinvictor	Excel Discussion (Misc queries)	1	June 14th 06 04:28 PM
100% cpu usage	bill	Excel Discussion (Misc queries)	1	March 2nd 06 10:27 AM

All times are GMT +1. The time now is 12:51 PM.

About Us

"It's about Microsoft Excel"