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

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

named Range Referenced vai single cell 1
Visual Basic 10
Changing range based on Date 5
Code Adjustment 3
Searching Lists 4
Duplicating worksheet based on range and changing worksheet name 3
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Index, Match within a range of values 4

Top