Hi There
I am running Excel 2007.

I have 2 columns consisting of 1316 rows. In Column A and Column B the same
figures apply. However the sum of Column A =sum(A11:A1315) = 5,901,195.18 and
Column B =sum(B11:B1315) = 0.

I have tried pressing F9 to recalculate but it doesn't do anything
By way of further information I do have lots of other Lookups,and other
formula in the sheet. The sheet does contain a lot of info.

Is this a memory problem or What - weird !

All help or advice greatfully accepted

--
Wales - the land of fire breathing dragons and rugby playing wizards.