STEP 7: Enter the Subtotal function and for the first argument function_num we will reference the Cell Link from STEP 6 We will use this value as our first argument in the SUBTOTAL function) (The Cell Link increments by 1 depending on the order of the list and the name chosen. STEP 6: For the Cell Link, you need to select a cell where you want to show the output and press OK
STEP 5:For the Input Range, you need to select the range with the Subtotal summary names from STEP 1 STEP 4: Right Click on the Combo Box and select Format Control… STEP 3: With your mouse select the region where you want to insert the Combo Box STEP 2: In the ribbon select Developer > Insert > Form Controls > Combo Box STEP 1: We need to list the Subtotal summary functions in our Excel worksheet
