View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cinco Cinco is offline
external usenet poster
 
Posts: 29
Default Storing formula in cell

I want to save the following formula in a cell:

=Sumif(Indirect("S" &Q5+1 &":S" &R5),"<" &V2,Indirect("R" &Q5+1 &":R" &R5))"


I've tried using double "s at various places but with no success. The
formula that is saved does not match the one above. Any ideas on what the
right combination of " is for this formula so I can save a copy in a cell?
Thanks.

Jim