#1
|
|||
|
|||
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 D614. 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 |