@kubi

Hi
if you have a new question, even pertaining to an existing thread, it's always best to start a new thread eventually adding a link.
This will give you a better chance of getting an answer



I did it for you this time

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I am having trouble with column M returning a carton count even if a full pallet has been picked which then makes the final count wrong.

Inners and pallet counts work fine, just carton picks needing fixing.

Any help?

Attached Files

Test#2.xlsx (11.2 KB, 12 views)

It seems difficult for you to give illustrative examples with expected results.

Attached Files

Boxes_3.xlsx (12.2 KB, 15 views)