| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I count a named range for a specific word or acronym?
I am trying to count how many times the acronym "SD" shows up for all
worksheets in my file and on a specific row. |
|
#2
|
|||
|
|||
|
How do I count a named range for a specific word or acronym?
Hi!
One way: Create a list of all the sheet names. Give this list a defined name,say, List. Then, to count instances of SD on every sheet in row 10: =SUMPRODUCT(COUNTIF(INDIRECT("'"&List&"'!10:10")," SD")) Biff "brandyb" wrote in message ... I am trying to count how many times the acronym "SD" shows up for all worksheets in my file and on a specific row. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables - Named Range | Excel Worksheet Functions | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
| Identifying single column within named range | Excel Discussion (Misc queries) | |||
| Vlookup of parts of a word in a range of Data | Excel Discussion (Misc queries) | |||
Linear Mode
