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

1. ## 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. ## Re: Named range=Column title,comumn title in cellB6 use B6in equation

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

HTH
--
AP

"Graham" <Graham@discussions.microsoft.com> a écrit dans le message de news:
CC8D53B2-AB97-4DFF-8B7F-7375C9E3D66A@microsoft.com...
>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. ## Re: 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" <Graham@discussions.microsoft.com> wrote in message news:CC8D53B2-AB97-4DFF-8B7F-7375C9E3D66A@microsoft.com...
>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"))
>

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1