thanks for your help everyone, i think i have it now

Mally

"R.VENKATARAMAN" wrote:

type in B1
=INDIRECT("A1")

still B1 will contain some formula but may not be the formula of A1.
however as the formula in A1 changes the value in B1 also will change.

is this what you want??


Mally wrote in message
...
I have a a cell containing a formula to display a total time.

e.g. A1 contains =SUMIF($E$5:$E$25,$E28,$D$5:$D$25). This is my actual
formula. The answer it gives is 01:00 in time format.

Is it possible to display the answer to the formula in cell B1 but not to
contain the formula. B1 needs to change as A1 does.