AutoSum?

M

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
 
P

Pete JM

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

Pet
 
D

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)
 
Top