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"))

Named range=Column title,comumn title in cellB6 use B6in equation
 

=COUNTIF(INDIRECT(B6),"wip")

HTH
--
AP

"Graham" a écrit dans le message de news:
...
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"))

Named range=Column title,comumn title in cellB6 use B6in equation
 

Hi Graham

See the help for Indirect
=COUNTIF(INDIRECT(B6),"wip")


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Graham" wrote in message ...
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"))