|
|
#1
04-07-2019, 02:02 PM
|
|||
|
|||
Counting phrases on different sheets.
Helllo, I have thirty sheets where I'm trying to count how many times a certain phrase in the range of D6  14. In those cells I have drop down list filled with 10 different options. For example ”release for service”, I would like to see how many times that appears on all 30 sheets on my master sheet. I already have the sheets names in a list called ”dayslist”. I was trying sum product and countif and keeping coming back with 0 or #ref. Thanks.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Deleting phrases or from one point to another?
|
juddman | Excel | 4 | 10-03-2015 05:40 AM |
| Counting unique visitors by ward, counting monthly visits by status, editing existing workbook | JaxV | Excel | 9 | 11-14-2014 12:25 AM |
| Counting Keywords and Phrases | tlamae | Excel | 5 | 05-30-2014 06:49 AM |
| Linking sheets to fetch transactions from sheets to another | waqer | Excel | 4 | 09-01-2011 12:35 PM |
|
Automatically Hyperlink phrases
|
TinaIgnatiev | Word | 1 | 12-22-2010 01:42 PM |
Windows Vista 
Office 2016
Threaded Mode