Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-07-2019, 02:02 PM
Greggey1 Greggey1 is offline Windows Vista Office 2016
Novice
 
Join Date: Mar 2019
Posts: 10
Greggey1 is on a distinguished road
Default 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.
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 08:53 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft