View Single Post
  #2   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

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.