14. Dean wishes to determine several totals and averages for his staff.
In cell Q9, enter a formula using the COUNTIF function and structured references to count the number of staff members who have participated in Leadership Training.

The formula for Countif function is =countif(range,criteria). Suppose, we have 7 number of people working with Dean and they attended different training during the period. We will first make a table on Excel stating names and training of the employees. We will now apply the formula by selecting the whole table when entering range and writing “Leadership Training” when entering criteria. The answer to this will be 3 as 3 people have received leadership training. Make sure to enter the text/criteria here in inverted commas.

Table

Names - Training

Karen - Stress Management

Ali - Data Modelling

Ayesha - Leadership Training

Sonia - Leadership Training

Naveen - Stress Management

Fawad - Leadership Training

Kiara - Data Modelling

14. Dean wishes to determine several totals and averages for his staff. In cell Q9, enter a formula using the COUNTIF function and structured references to count the number of staff members who have participated in Leadership Training.

Respuesta :

Answer with Explanation

Table

Otras preguntas

14. Dean wishes to determine several totals and averages for his staff.
In cell Q9, enter a formula using the COUNTIF function and structured references to count the number of staff members who have participated in Leadership Training.