In cell q9 enter a formula using the countif function and structured references to count the number of staff members who have pa
rticipated in [leadership training]
1 answer:
Uses of count function 1.0 COUNTA(range) - when COUNTA() is used, it counts the number of entries on the particular range defined. As long as the cell on the range specified is not emptye.g. Formula is COUNTA(A2:A13), The result would be 12. We have 12 non empty entries on the range
2.0 COUNTIF() - counts the entries on the specified range which satisfies the given conditione.g. Formula is COUNTIF(A2:A13,"Staff"), the result of this is '4'. Where it is specified to count cells with text "Staff" Note : "" (double quotes), denotes that the entry inside is text.
Find attached Sample
2.0 COUNTIF() - counts the entries on the specified range which satisfies the given conditione.g. Formula is COUNTIF(A2:A13,"Staff"), the result of this is '4'. Where it is specified to count cells with text "Staff" Note : "" (double quotes), denotes that the entry inside is text.
Find attached Sample
You might be interested in
Answer:
The following are the answer to the given points:
Explanation:
In point (a):
Calculating the long-distance call cost:
Calculating the local call cost:
Calculating the overall cost of PSTN:
In point (b):
Calculating the call rate per second and the average arrival rate:
The call average length:
The complete agent number:
The strength of traffic:
The occupancy of the agent:
Calculation of obtained:
We get = 0.329 to substitute values.
In point (c):
The rate of blocking =
average call time
In point (d):
Calculating the number of link, which is required:
In point (e):
Calculating the Line Number:
PSTN line number:
In point (f):
The gross design expense = $ 2309. 5