Firstly, post the formula you are getting
and secondly make sure you have formatted the cell as number.

Regards
Michael M

"Jooles" wrote:

I am trying to add a cell from one worksheet to a formula in another
worksheet but it just shows the forumula in the total box instead of the
figure what am I doing wrong?
--
Jooles