Quote:
Originally Posted by lonniepoet
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.