View Single Post
 
Old 12-13-2015, 10:30 AM
excelledsoftware excelledsoftware is offline Windows 10 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