Page 120 - Excle-En-V3

First level: The total number of all orders for all areas

Figure 171: First level of SUBTOTAL

The second level: The number of orders for each region in brief

Figure 172: Second level of SUBTOTAL

The third level: It is the detailed level that displays all the details
To calculate the total quantity of orders for each area, click the Subtotal
command from the Data menu, and choose for each change in “Area” to use the
“Sum” function and add a subtotal to “Quantity” and then “OK.”

Figure 173: Subtotal for total order quantity

112 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024