hello all,

I have a formula as follows.

=SUMPRODUCT(--(A78=Yield!$A$13:$A$35000),--(S78>Yield!$G$13:$G$35000),--(S78<=Yield!H$13:$H$35000),(Yield!$D$13:$D$35000))


I am trying to copy this formula to the whole column. The way I am doing this is by copying the formula in the first cell using ctrl + c and selecting the whole column and using ctrl+V. This method copies the value in the first cell to the whole 65000 rows. And when i click on any cell it looks like the formula has been copied down correctly but the values are not computed properly. whereas instead of copy and paste if I drag the formula to other cells it seems to be working fine. But the problem with this method is i have so many formulas that i need to copy in so many columns for different workbooks that this process is taking too long. What am i doing wrong with copy and paste option. Please advise.