Re: sumproduct snafu

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In article <44EED757-885F-4BAA-AB55-68D0208D761E@xxxxxxxxxxxxx>,
Coal Miner <CoalMiner@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

By the way - This is MUCH faster than the sumproduct (i'm sure you are aware
of that though).

Yes, it's much more efficient. That's why I didn't bother offering a
solution using built-in functions. With a large range such as yours,
using built-in functions would be extremely inefficient...
.