AutoSum?

[Manhar]

I want a text entry in one cell also to appear in another
cell automatically. I highlighted the second cell,
clicked on Autosum and then clicked on "source cell" and
was returned a "0". The cell entry was "April 2004".
Your help is appreciated! Manhar

 

[Frank Kabel]

Hi
if your source cell is A1 enter the following in the second cell:
=A1

 

[Pete JM]

Type = in the cell that you want the data to appear then click on th
cell that contains the original text.

Pet

 

[Dave Peterson]

Autosum will try to add the numeric values in that range you pointed to.

I think you just want a formula:

Type =, then point at that other cell.

You'll end up with something like:

=B13
or
=sheet2!b13
(if it's on a different worksheet.)

If that cell is empty, you'll get a 0. You can avoid that by modifying the
formula:

=if(b13="","",b13)
or
=if(sheet2!b13="",sheet2!b13)