Quote Originally Posted by p45cal View Post
Look at cells A5:E7 of the Sheet2 sheet in the attached.
It assumes you have static sets of values for the Service Level and Shipment columns, because the hard-coded values in the formula (circled in the pic below) represent what's included in the count. You can add/remove hard-coded values in those parts of the formula. They must be comma separated, regardless of which locale you're in.
There are only 3 formulas, copied across.

2024-06-11_002512.jpg

Do check the values are correct.
My god, this works ! I get the exact same resultats as when I did it manually. I am so grateful for your help. This will help the team a ton, because the report is quite big.

Thank you so much.