select the cell and do edit=copy.
Select the destination and do Edit=Paste
this will copy an array formula.
if you do ctrl+C and ctrl+V to a selected cell and not to the formula in the
formula bar, it should work as well. Always has for me.
--
Regards,
Tom Ogilvy
"Ramakrishnan Rajamani"
wrote in message ...
I have a conditional sum in a cell, which I wish to copy to another
cell(s).
I tried to ^C and ^V but it does not work. For each repeat, I am forced
to
use the Conditional Sum wizard. Is there a way out or the repeated use of
Conditional Sum Wizard is the only way.
Help appreciated.
|