Hi,
I'm orfinarily okay with most formulas, but this has got me stumped. I've copied a formula over from another worksheet and copied it down (by dragging) all the cells I want to apply the formula to...however it returns only the answer to the first cell...

Next, I deleted it and started afresh, doing 4 or 5 new formulas and then dragging the 5th down when they were returning the correct answer - again, dragging the cell down (2500 times) still returns the answer to the 5th formula.

However, if I go into each cell, click on the autosum icon to open up the formula and click okay, it refreshes the cell and returns the correct answer - even though I've not done anything to it and all data remains the same (which is correct).

Any ideas as I don't fancy going into each cell to do this...
Cheers,
Jo