johnthienann7814 johnthienann7814 03-04-2024 Computers and Technology contestada Apply a drop-down list to cell m6 (3 states: nsw, qld, vic) and create a formula in cell o6 to calculate the number of jobs in the selected state.