If that is your case I am afraid we cannot access the SUM function in Words table because it is not designed to do such thing. Write down the specific criteria in E9 and E10. SUM Calculates the sum of items identified inside the parentheses.
SUMIFA2A6KTEB2B6 A2A6 is the data range which you add the values based on KTE stands for the criterion you need and B2B6 is the range you want to sumsee screenshots.
Take a separate column E for the criteria and F for the total quantity. You can use IF statements AND and OR operators and more. Evaluates whether the argument is true. In order to add the sum range based on a specific text criteria we need to.