View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
tim2216 tim2216 is offline
external usenet poster
 
Posts: 6
Default Copying formulas

Is there an easy way to copy this to about 700 cells?

=SUMPRODUCT((A4:A11998=S6)*(B4:B11998=V3))

there has to be an easier way to copy this.