Posted to microsoft.public.excel.programming

RJMAT

external usenet poster

Posts: 6

Mulitple SUMPRODUCTS?

Thank You Alexander,

This did the trick. I am very happy now.

Have a nice day!

"Alexander Wolff" wrote:

Hi Rich,

rather use *, not the comma between complex sumproduct terms. It is one of
the many cases the favorable comma (10% faster) does not work.
--
Moin+Gruss Alexander - MVP fÃ¼r MS Excel - www.xxcl.de - mso2000sp3 --7-2

Reply With Quote

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

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
multiple sumproducts and now formula is too long	sam	Excel Discussion (Misc queries)	3	April 14th 10 09:59 AM
Dates and SumProducts	Jeff Gross	Excel Worksheet Functions	2	September 5th 08 05:58 PM
Problems with SUMPRODUCTS	John21	Excel Worksheet Functions	2	August 9th 06 05:53 PM
SUMPRODUCTS	AJP	Excel Worksheet Functions	4	July 14th 06 06:13 PM
Sumproducts, Counta Lookup Ref Formulas	JR573PUTT	Excel Discussion (Misc queries)	7	February 15th 06 11:31 PM

All times are GMT +1. The time now is 11:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us