Microsoft Office Forums Counting phrases on different sheets.

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2019, 02:02 PM
Greggey1 Greggey1 is offline Counting phrases on different sheets. Windows Vista Counting phrases on different sheets. Office 2016
Novice
Counting phrases on different sheets.
 
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
Counting phrases on different sheets. 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
Counting phrases on different sheets. Automatically Hyperlink phrases TinaIgnatiev Word 1 12-22-2010 01:42 PM


All times are GMT -7. The time now is 09:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft