Thread: Named range=Column title,comumn title in cellB6 use B6in equation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Graham Graham is offline
external usenet poster
  
Posts: 155
Default Named range=Column title,comumn title in cellB6 use B6in equation
I am trying to type a column title in a cell say B6, the column title = a
named range.
then I want to use the cell reference B6 in an equation that counts the
number of times a word appears in the named range? Is this Possible?
example SUMPRODUCT(--(b6="wip"))

Reply With QuoteReply With Quote