Aladin I have a question for ya
Posted by Kevin on January 16, 2002 2:42 PM
I have a spreadsheet in which I am using a formula that I read in one of your posts. It is the sumproduct() function, similar to sumif() but you can specify more than just one condition. The workbook contains one sheet that has a table of data, and three other sheets that contain these sumproduct() functions summarizing the table of data in different ways. There are approx. 16 of these functions on each of the three summary sheets. The function works great, by the way, except for one thing:
My problem is these functions appear to be making my spreadsheet run extremely slow. Each time I enter data into one of the cells in my data table, it takes around 10 seconds to recalculate the spreadsheet. The spreadsheet file itself is not very large, only about 44.5kb. I am at a loss - is it possible that these formulas are slowing down the performance this much? If so, are there any alternatives to using the sumproduct() function that will yield the same results?
Thank you for your help,