Thanks for the complement.


I'll correct my copy. And let Lonnie correct his.

Attached Files

2016 test_NAT Reship Log-1.xlsm (32.5 KB, 11 views)

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...

Attached Files

Copy of 2016 test_NAT Reship Log-1.xlsm (33.5 KB, 9 views)

Lonnie, look into the formula SUBTOTAL (totals only the visible cells) and see if that will do what you need.

I was tinkering with the subtotal formula, but I need it to only total the fields that are specific to each SKU# in column 'A'. For example, I need it to list all occurrences for "New Acct", "Damaged", etc. specific for 945DU2869 and so on. This spreadsheet will end up having over 1,000 entries when it is all said and done. Thank you in advance for looking into this.

Attached Files

Copy of 2016 test_NAT Reship Log-1.xlsm (33.5 KB, 10 views)