sumproduct issues

Hi,

I'm using the SUMPRODUCT function and I noticed that,it calculates as soon as I input a data on the cell,thus, making the process slow, so slow. is there a way that i can speed up the process of completing my data entry before the SUMPRODUCT calculates?

thanks so much for your help...

THANKS SO MUCH!...THIS IS VERY MUCH APPRECIATED!!! THANK YOU! THANK YOU!

Originally Posted by NBVC

You can set calculations to Manual through Tools|Options >> Calculation tab...

Then after you input all your data, hit F9 to re-calculate your sheet.