DIV/0 error means you are dividing by 0, When you copy paste, did you paste in the exact same location as well? being that all of your references are not absolute it is possible that it is trying to obtain values that may not be there.

Can you post a copy of this example - then we can take a look and make better suggestions. If it works in one it should work in the other, I would have to assume without seeing it that your references are to empty cells -

Or as Marvin pointed out, could be formatting...

Go Advance (ALT+X) and share a sample so we can see what is occurring.