Copying result of formula into another worksheet???
 

I am having problems copying a formula result into another wksht if the
formula is not used...hard to explain...

D10=Sum(A1:A5)

I want to transfer D10 to wksht Data E12, however if there is no data in
A1:A5, I want E12 to remain blank.

It looks like it is reading the formula, so it places a "0" or a "-"....

Any ideas?

Tools - Options - View

Turn off zero values should get you part of the way.

"Amanda" wrote:

I am having problems copying a formula result into another wksht if the
formula is not used...hard to explain...

D10=Sum(A1:A5)

I want to transfer D10 to wksht Data E12, however if there is no data in
A1:A5, I want E12 to remain blank.

It looks like it is reading the formula, so it places a "0" or a "-"....

Any ideas?

Amanda,

Try a formula like

=IF(COUNT(A1:A5)=0,"",SUM(A1:A5))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Amanda" wrote in message
...
I am having problems copying a formula result into another wksht
if the
formula is not used...hard to explain...

D10=Sum(A1:A5)

I want to transfer D10 to wksht Data E12, however if there is
no data in
A1:A5, I want E12 to remain blank.

It looks like it is reading the formula, so it places a "0" or
a "-"....

Any ideas?

Thanks! That worked!!

"Chip Pearson" wrote:

Amanda,

Try a formula like

=IF(COUNT(A1:A5)=0,"",SUM(A1:A5))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Amanda" wrote in message
...
I am having problems copying a formula result into another wksht
if the
formula is not used...hard to explain...

D10=Sum(A1:A5)

I want to transfer D10 to wksht Data E12, however if there is
no data in
A1:A5, I want E12 to remain blank.

It looks like it is reading the formula, so it places a "0" or
a "-"....

Any ideas?