Excel 2007 - Sum Product help

[plsimmo]

I recently began using the Sum Product formula. However i have noticed that this utilizes ALOT of processing power. I this normal, or do i need to change something in my settings. I have once workbook with two sheets. One has the raw data on it. The other has a matrix that contains the SumProduct formula. ie =SUMPRODUCT(--(Sheet2!$E:$E=Sheet1!$A3),--(Sheet2!$C:$C=Sheet1!C$1),(Sheet2!$I:$I))

I only have 1776 cells with this formula in it and cannot work out why the file size is 2,525KB and hammers the PC.

Any advice appreciated.
Thanks
Paul

 

[Matty]

It's kind of hard to explain (in a few sentences) when it's not a good idea to use volatile functions. Most of the time it's probably just fine.

The easiest way I can tell when you shouldn't use volatile functions is...

When you type something in a cell then hit Enter and you notice a "delay" in the amount of time it takes for the entry to register and the cell selector to move to the next cell (if you have it set to do that).

That's a sure sign that you need to think about more efficient methods!

Thanks Biff. I'll bear that in mind going forward!

Matty

 

[T. Valko]

Thanks Biff. I'll bear that in mind going forward!

Matty

You're welcome!