| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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")) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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")) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
