Posted to microsoft.public.excel.worksheet.functions

diaare

external usenet poster

Posts: 50

SumProduct too slow

I have a worksheet filled with formulas similiar to this one:

=IF(SUMPRODUCT((ProductionDate=G$3)*(LineID=$D5)*( QtyProduced))=0,1E-50,(SUMPRODUCT((ProductionDate=G$3)*(LineID=$D5)*( QtyProduced))))

Where ProductionDate, LineID, and QtyProduced are neamed ranges on a
different tab of the same workbook.

If is very very slow to calculate.

Does anyone have a suggestion on how to speed things up?

Thanks,
Diane

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
Slow Sumproduct	wx4usa	Excel Discussion (Misc queries)	1	August 26th 07 11:23 PM
SumProduct making things work slow	Adam Graham	Excel Worksheet Functions	7	February 4th 07 08:41 AM
Sumproduct Slow	wx4usa	New Users to Excel	4	January 27th 07 07:05 PM
Sumproduct formulas & slow response	Darby	Excel Worksheet Functions	1	November 21st 05 09:21 PM
sumproduct formula to slow	Todd	Excel Worksheet Functions	4	December 21st 04 11:25 PM

All times are GMT +1. The time now is 08:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us