Thread: Substitution
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mitchell Mitchell is offline
external usenet poster
 
Posts: 19
Default Substitution

When defining a range can you use a reference instead of the actual value?

countif(m6:m429,"ION")

Can I replace the 429 with a reference to a cell containing the 429?