Calculate the total Annual Units Sold that show up in the results.
If the third character in the employee ID is 0, or 2, or 4 or 6 or 8, insert the employee’s Annual Units Sold, otherwise the cell should be blank. Copy the function down to the other cells in the column. In cell V10 use the appropriate function to calculate the total Annual Units Sold […]