View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Crawford
 
Posts: n/a
Default moving a formula

See my formula...
=COUNTIF(All!A2:A844, Feb06!A1)

When I copy my formula to the next cell I only want Feb06!A1 to increase to
A2, A3, and so on. But A2:A844 should remain. What should I do?