Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 12-13-2015, 10:30 AM
excelledsoftware excelledsoftware is offline Filter Search Button Windows 10 Filter Search Button Office 2007
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Quote:
Originally Posted by lonniepoet View Post
That is even better! This is exactly what I need. This will allow for the other users to access the information way easier. However, I was recently given another task by management to add and calculate data for each SKU# being entered. They would like me to calculate the percentage of mistakes (per specific mistake) for each one. I added the fields they'd like to track and the sheet they'd like in order to get their "program summary report." I know how to do all the simple calculations, but how to I get the program summary report to track a total for each reason per each SKU# and not pulls sums/totals of the other SKUs? Any help would be much appreciated. Let me know if I should open up a new forum or something since this is a different issue. It could be seen as an added issue I suppose...
Lonnie, look into the formula SUBTOTAL (totals only the visible cells) and see if that will do what you need.
Reply With Quote
 

Tags
button, filter, search



Similar Threads
Thread Thread Starter Forum Replies Last Post
Onenote 2013 search is not identifying search terms correctly Delta223 OneNote 0 08-12-2014 06:40 AM
Search for date and then apply mutliple search criteria in huge dataset maxtymo Excel 2 12-01-2013 04:52 AM
Looking for Windows Search app with ability to search by content gopher_everett Office 1 02-28-2013 09:23 PM
Instant Search's "Display search results as I type when possible" with Exchange lwc Outlook 0 06-01-2011 01:56 AM
Search and Replace - Clear Search box JostClan Word 1 05-04-2010 08:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:41 PM.


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