SUMPRODUCT Excel functionality
Hi,

it's not a real issue, though I'm having some hard hours because of it. The simple SUMPRODUCT (=weighted average of columns) is not possible with current solutions, or I missed something. Whatever solution I used they all caused my computer to crash. The same amount of data can be calculated in Excel (100,000 rows and 30 columns).
I know I made errors during my implementations (because this amount of data shouldn't crash a comp), so can you help me writing a script that does this work?

Thanks
guyko