View Single Post
 
Old 03-28-2012, 01:11 AM
bosve73 bosve73 is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Aug 2010
Posts: 6
bosve73 is on a distinguished road
Default

I narrowed it down to the formula that I use SUMPRODUCT is what is causing the slowdown:

=SUMPRODUCT((Department="Red")*(Status="Start"))
Is there a better way to do this?
Reply With Quote