Column A,B,C,D and E contain Code, category, Type 1, Type 2 and Total stock. I am trying to achieve sumifs according to the material type and
category. I am apply 5 different array formulas for the following data. I need one non array formula for all together.
Any help much appreciated...